/*
 Navicat Premium Data Transfer

 Source Server         : 118.25.217.76
 Source Server Type    : MySQL
 Source Server Version : 50613
 Source Host           : 118.25.217.76
 Source Database       : base-frame

 Target Server Type    : MySQL
 Target Server Version : 50613
 File Encoding         : utf-8

 Date: 02/10/2019 00:30:40 AM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `cms_article_items`
-- ----------------------------
DROP TABLE IF EXISTS `cms_article_items`;
CREATE TABLE `cms_article_items` (
  `Art_ID` varchar(37) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Art_Title` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标题',
  `Art_Label` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类别ID',
  `Art_Imgs` text COLLATE utf8mb4_unicode_ci COMMENT '文章中的所有图片路径',
  `Art_SignImg_s` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标志图 小图',
  `Art_SignImg_b` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标志图 大图',
  `Art_Content` longtext COLLATE utf8mb4_unicode_ci COMMENT '内容',
  `Art_CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `Art_ReadCount` int(11) DEFAULT NULL COMMENT '阅读数量',
  `Art_Intro` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '简介',
  `Art_ArticleFrom` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '来路（TextBox）',
  `Art_PartnersID` int(11) DEFAULT '0' COMMENT '企业ID',
  `Art_OrgID` int(11) DEFAULT '0' COMMENT '组织结构ID',
  `Art_UserID` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '发布者ID',
  `Art_VideoPath` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '视频文件地址',
  `Art_IsRecommend` tinyint(1) DEFAULT '0' COMMENT '是否推荐',
  `Art_IsPreShowImg` tinyint(1) DEFAULT '0' COMMENT '是否把封面显示在图文信息前',
  `Art_ViewStyle` smallint(6) DEFAULT '0' COMMENT '视图样式',
  `Art_IsHide` smallint(6) DEFAULT '0' COMMENT '是否隐藏',
  PRIMARY KEY (`Art_ID`),
  KEY `Art_Label` (`Art_Label`),
  KEY `Art_IsRecommend` (`Art_IsRecommend`),
  KEY `Art_IsPreShowImg` (`Art_IsPreShowImg`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `cms_article_items`
-- ----------------------------
BEGIN;
INSERT INTO `cms_article_items` VALUES ('C853BA15-0920-0001-C1C6-5D1614993620', '测试1', '18,4', '', null, null, '<p>qeqwe1231<br></p><p>12312</p><p>3123</p><p>123123</p>', '2019-02-09 23:50:11', '0', 'qwwqq', null, '-1', '-1', '1', '', '0', '0', '6', '0');
COMMIT;

-- ----------------------------
--  Table structure for `cms_article_items_label_code`
-- ----------------------------
DROP TABLE IF EXISTS `cms_article_items_label_code`;
CREATE TABLE `cms_article_items_label_code` (
  `AR_ID` varchar(37) COLLATE utf8mb4_unicode_ci NOT NULL,
  `AR_LabelCode` char(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分类编码',
  `AR_ArtID` varchar(37) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图文信息ID',
  PRIMARY KEY (`AR_ID`),
  KEY `AR_ArtID` (`AR_ArtID`),
  KEY `AR_LabelCode_2` (`AR_LabelCode`,`AR_ArtID`),
  CONSTRAINT `cms_article_items_label_code_ibfk_1` FOREIGN KEY (`AR_ArtID`) REFERENCES `cms_article_items` (`Art_ID`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `cms_article_items_label_code`
-- ----------------------------
BEGIN;
INSERT INTO `cms_article_items_label_code` VALUES ('C853BBA4-DC40-0001-D799-14B257421715', '18', 'C853BA15-0920-0001-C1C6-5D1614993620'), ('C853BBA4-DCD0-0001-4169-46C21F7817E3', '4', 'C853BA15-0920-0001-C1C6-5D1614993620');
COMMIT;

-- ----------------------------
--  Table structure for `cms_article_label`
-- ----------------------------
DROP TABLE IF EXISTS `cms_article_label`;
CREATE TABLE `cms_article_label` (
  `al_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `al_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '标识编码',
  `al_parent_id` int(10) NOT NULL COMMENT '父级编号',
  `al_isparent` tinyint(1) DEFAULT '0' COMMENT '是否是父级',
  `al_parent_ids` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '所有父级编号',
  `al_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '名称',
  `al_type` char(3) DEFAULT '0' COMMENT '类型(001-公共 002-自建 003-排版)',
  `al_sort` int(10) NOT NULL COMMENT '排序',
  `al_other_attr` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '自定义属性',
  `al_partners_id` int(11) DEFAULT '0' COMMENT '企业ID',
  `al_org_id` int(11) DEFAULT '0' COMMENT '部门ID',
  `al_create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '创建者',
  `al_del_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  `al_is_write` tinyint(4) DEFAULT '1' COMMENT '是否可写',
  `al_description` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '描述',
  `al_create_date` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`al_id`),
  KEY `sys_mdict_parent_id` (`al_parent_id`),
  KEY `sys_mdict_del_flag` (`al_del_flag`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='文章分类表';

-- ----------------------------
--  Records of `cms_article_label`
-- ----------------------------
BEGIN;
INSERT INTO `cms_article_label` VALUES ('3', '02', '0', '1', '0,', '学习交流', '001', '1', null, '-1', '-1', '1', '0', '1', null, '2018-07-11 15:04:42'), ('4', '0202', '3', '0', '0,3,', '育苗指导', '001', '1', '{\'IsSelected\':true,\'img1\':\'{host}/static/image/label-img/育苗.png\'}', '-1', '-1', '1', '0', '1', null, '2018-07-11 15:04:42'), ('5', '0203', '3', '0', '0,3,', '田间管理', '001', '2', '{\'img1\':\'{host}/static/image/label-img/田间.png\'}', '-1', '-1', '1', '0', '1', null, '2018-07-11 15:04:42'), ('6', null, '3', '0', '0,3,', '精准施肥', '001', '5', '{\'img1\':\'{host}/static/image/label-img/施肥.png\'}', '-1', '-1', '1', '0', '1', '', '2018-07-11 15:04:42'), ('7', null, '3', '0', '0,3,', '病害防治', '001', '6', '{\'img1\':\'{host}/static/image/label-img/病害.png\'}', '-1', '-1', '1', '0', '1', null, '2018-07-11 15:04:42'), ('8', null, '3', '0', '0,3,', '成熟采收', '001', '4', '{\'img1\':\'{host}/static/image/label-img/采收.png\'}', '-1', '-1', '1', '0', '1', null, '2018-07-11 15:04:42'), ('9', '0204', '3', '0', '0,3,', '专业化烘烤', '001', '3', '{\'img1\':\'{host}/static/image/label-img/烘烤.png\'}', '-1', '-1', '1', '0', '1', null, '2018-07-11 15:04:42'), ('10', null, '3', '0', '0,3,', '专业化分级', '001', '8', '{\'img1\':\'{host}/static/image/label-img/分级.png\'}', '-1', '-1', '1', '0', '1', null, '2018-07-11 15:04:42'), ('11', null, '3', '0', '0,3,', '政策宣传', '001', '7', '{\'IsSelected\':true,\'img1\':\'{host}/static/image/label-img/政策.png\'}', '-1', '-1', '1', '0', '1', null, '2018-07-11 15:04:42'), ('12', '0201', '3', '0', '0,3,', '产品说明', '001', '0', '{\'IsSelected\':true,\'img1\':\'{host}/static/image/label-img/说明.png\'}', '-1', '-1', '1', '0', '0', null, '2018-07-11 15:04:42'), ('17', '01', '0', '1', '0,', 'app推荐', '001', '0', null, '-1', '-1', '1', '0', '1', null, '2018-07-11 15:04:42'), ('18', '0102', '17', '0', '0,17,', '首页头部', '001', '0', null, '-1', '-1', '1', '0', '1', null, '2018-07-11 15:04:42'), ('19', '0103', '17', '0', '0,17,', '学习模块首页头部', '001', '0', null, '-1', '-1', '1', '0', '1', null, '2018-07-11 15:04:42');
COMMIT;

-- ----------------------------
--  Table structure for `cms_site_config`
-- ----------------------------
DROP TABLE IF EXISTS `cms_site_config`;
CREATE TABLE `cms_site_config` (
  `sc_key` varchar(50) NOT NULL,
  `sc_label` char(10) DEFAULT NULL,
  `sc_name` varchar(50) DEFAULT NULL,
  `sc_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`sc_key`),
  KEY `sc_label` (`sc_label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `cms_site_config`
-- ----------------------------
BEGIN;
INSERT INTO `cms_site_config` VALUES ('siteName', 'system', '站点名称', '疯子田CMS系统');
COMMIT;

-- ----------------------------
--  Table structure for `cms_site_menu`
-- ----------------------------
DROP TABLE IF EXISTS `cms_site_menu`;
CREATE TABLE `cms_site_menu` (
  `sm_id` char(36) NOT NULL,
  `sm_parentId` char(36) DEFAULT NULL COMMENT '父级ID',
  `sm_isParent` tinyint(4) DEFAULT '0' COMMENT '是否是父级',
  `sm_name` varchar(20) DEFAULT NULL COMMENT '栏目名称',
  `sm_showAddr` tinyint(4) DEFAULT '0' COMMENT '显示位置 0：不显示 1：头部 2：下部 3：都显示',
  `sm_sort` int(11) DEFAULT NULL COMMENT '排序',
  `sm_blank` tinyint(4) DEFAULT '0' COMMENT '是否在新窗口中打开',
  `sm_url` varchar(255) DEFAULT NULL COMMENT '跳转的URL地址',
  `sm_icon` varchar(50) DEFAULT NULL COMMENT '图标',
  `sm_attr` varchar(255) DEFAULT NULL COMMENT '附加属性',
  PRIMARY KEY (`sm_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `cms_site_menu`
-- ----------------------------
BEGIN;
INSERT INTO `cms_site_menu` VALUES ('C83339C6-FC00-0001-D7F5-E0E0C41015DF', '0', '0', '首页', '1', '1', '1', '/', '1', null);
COMMIT;

-- ----------------------------
--  Table structure for `cms_site_module`
-- ----------------------------
DROP TABLE IF EXISTS `cms_site_module`;
CREATE TABLE `cms_site_module` (
  `sm_id` char(36) NOT NULL COMMENT 'ID',
  `sm_name` varchar(50) DEFAULT NULL COMMENT '模块名称',
  `sm_isSys` tinyint(4) DEFAULT '0' COMMENT '是否是系统模块',
  `sm_viewPath` varchar(50) DEFAULT '' COMMENT '使用的视图地址',
  `sm_realViewPath` varchar(50) DEFAULT '' COMMENT '真正使用的视图地址',
  `sm_url` varchar(100) DEFAULT NULL COMMENT 'url地址',
  `sm_keyWord` varchar(255) DEFAULT NULL COMMENT '关键词',
  `sm_pageTitle` varchar(50) DEFAULT NULL COMMENT '页面标题',
  `sm_remark` varchar(100) DEFAULT NULL COMMENT '简单描述',
  `sm_createTime` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`sm_id`),
  UNIQUE KEY `sm_url` (`sm_url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='站点模块';

-- ----------------------------
--  Records of `cms_site_module`
-- ----------------------------
BEGIN;
INSERT INTO `cms_site_module` VALUES ('1', '首页', '1', 'index/index.marko', 'index/index.marko', '/', 'cms', '首页', '首页模板', '2018-10-25 16:27:16'), ('C830F565-9AB0-0001-1C62-AFD5128614D3', '新闻咨询-列表', '0', 'article/items.marko', 'article/items.marko', '/news/items/:label-:page', null, null, '新闻列表页模板', '2018-10-25 16:27:22'), ('C830F6D3-DC00-0001-B36A-15D1DE00172E', '新闻咨询-详情', '0', 'article/info.marko', 'article/info.marko', '/news/info/:id', null, null, '新闻详情页模板', '2018-10-25 16:27:25'), ('C8312FF0-DF70-0001-371B-52382A9CEFC0', '单页简介', '0', 'index/index.marko', 'index/index.marko', '/abstract/info', null, null, '', '2018-10-25 16:27:37'), ('C831309D-ED40-0001-E2D3-16EB3B021302', '意见反馈', '0', 'index/index.marko', 'index/index.marko', '/feedback/suggestion', null, null, '信息反馈，bug提交', '2018-10-25 16:32:30'), ('C83130CB-4190-0001-10D3-168014729300', '招聘-岗位列表页', '0', 'index/index.marko', '', '/recruit/items', null, null, '', '2018-10-25 16:37:28'), ('C83130E0-5360-0001-B8A3-F7F018191C57', '招聘-岗位详情', '0', 'index/index.marko', '', '/recruit/info', null, null, '', '2018-10-25 16:38:55'), ('C83130E9-5C20-0001-8889-12483D001D93', '招聘-申请岗位表单', '0', 'doc/doc.marko', '', '/recruit/Apply', null, null, '', '2018-10-25 16:39:32');
COMMIT;

-- ----------------------------
--  Table structure for `iframe_config`
-- ----------------------------
DROP TABLE IF EXISTS `iframe_config`;
CREATE TABLE `iframe_config` (
  `ConfigKey` varchar(50) NOT NULL,
  `ConfigValue` text,
  `ConfigInfo` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`ConfigKey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `iframe_config`
-- ----------------------------
BEGIN;
INSERT INTO `iframe_config` VALUES ('qq', '11', '123');
COMMIT;

-- ----------------------------
--  Table structure for `iframe_custom_theme`
-- ----------------------------
DROP TABLE IF EXISTS `iframe_custom_theme`;
CREATE TABLE `iframe_custom_theme` (
  `ct_id` char(36) NOT NULL,
  `ct_title` varchar(255) DEFAULT NULL COMMENT '名称',
  `ct_sign` varchar(50) NOT NULL COMMENT '标示 用于登录',
  `ct_system_name` varchar(50) DEFAULT NULL COMMENT '系统名称',
  `ct_org_id` int(11) DEFAULT '0' COMMENT ' 绑定的组织结构ID',
  `ct_login_bg` varchar(255) DEFAULT NULL COMMENT ' 登录页面背景图',
  `ct_logo_b` varchar(255) DEFAULT NULL COMMENT '大logo 用于登录页面',
  `ct_logo_s` varchar(255) DEFAULT NULL COMMENT '小logo 用于系统头部',
  `ct_create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`ct_id`),
  UNIQUE KEY `ct_sign` (`ct_sign`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='客制化设置';

-- ----------------------------
--  Records of `iframe_custom_theme`
-- ----------------------------
BEGIN;
INSERT INTO `iframe_custom_theme` VALUES ('1', '寻甸县烟草公司', 'xd', '寻甸县烟草公司', '1', '/res/upload/img/20180920/1537448294-9A9509.png', null, '/res/upload/img/20180620/1529501736-8E6308.png', '2018-06-20 06:57:30');
COMMIT;

-- ----------------------------
--  Table structure for `iframe_dict`
-- ----------------------------
DROP TABLE IF EXISTS `iframe_dict`;
CREATE TABLE `iframe_dict` (
  `zd_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '字典表',
  `zd_Name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `zd_value` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '值',
  `zd_label` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类型',
  `zd_type` smallint(6) DEFAULT '1' COMMENT '字典类型 1：系统 2：业务',
  `zd_sort` int(11) NOT NULL DEFAULT '0',
  `zd_ParentID` int(11) NOT NULL DEFAULT '0',
  `zd_IsParent` int(1) NOT NULL DEFAULT '0',
  `zd_IsShow` int(1) NOT NULL DEFAULT '1',
  `zd_Attr` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '属性',
  PRIMARY KEY (`zd_ID`),
  KEY `NewIndex1` (`zd_label`)
) ENGINE=InnoDB AUTO_INCREMENT=866 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `iframe_dict`
-- ----------------------------
BEGIN;
INSERT INTO `iframe_dict` VALUES ('27', '分类1', '001', 'ArticleLabel', '1', '1', '0', '0', '1', null), ('28', '云南省', '530000', 'area', '1', '2', '0', '0', '1', null), ('29', '寻甸回族彝族自治县 ', '530129', 'area', '1', '1', '28', '1', '1', null), ('38', '甸沙乡', '530129001', 'area', '1', '1', '29', '1', '1', ''), ('39', '甸沙村委会', '530129001001', 'area', '1', '1', '38', '1', '1', ''), ('40', '曹家村', '530129001001001', 'area', '1', '1', '39', '1', '1', ''), ('41', '茶厂', '530129001001002', 'area', '1', '2', '39', '1', '1', ''), ('42', '得秋哨', '530129001001003', 'area', '1', '3', '39', '1', '1', ''), ('43', '街上', '530129001001004', 'area', '1', '4', '39', '1', '1', ''), ('44', '李家村', '530129001001005', 'area', '1', '5', '39', '1', '1', ''), ('45', '麦地', '530129001001006', 'area', '1', '6', '39', '1', '1', ''), ('46', '洒井', '530129001001007', 'area', '1', '7', '39', '1', '1', ''), ('47', '撒米卡', '530129001001008', 'area', '1', '8', '39', '1', '1', ''), ('48', '山脑', '530129001001009', 'area', '1', '9', '39', '1', '1', ''), ('49', '田坝心', '5301290010010010', 'area', '1', '10', '39', '1', '1', ''), ('50', '小荒田', '5301290010010011', 'area', '1', '11', '39', '1', '1', ''), ('51', '杨家村', '5301290010010012', 'area', '1', '12', '39', '1', '1', ''), ('52', '云盘山', '5301290010010013', 'area', '1', '13', '39', '1', '1', ''), ('53', '海尾村委会', '530129001002', 'area', '1', '2', '38', '1', '1', ''), ('54', '大海尾', '530129001002001', 'area', '1', '1', '53', '1', '1', ''), ('55', '大清河', '530129001002002', 'area', '1', '2', '53', '1', '1', ''), ('56', '大湾田', '530129001002003', 'area', '1', '3', '53', '1', '1', ''), ('57', '烂泥箐', '530129001002004', 'area', '1', '4', '53', '1', '1', ''), ('58', '龙潭沟', '530129001002005', 'area', '1', '5', '53', '1', '1', ''), ('59', '石碑', '530129001002006', 'area', '1', '6', '53', '1', '1', ''), ('60', '水泡地', '530129001002007', 'area', '1', '7', '53', '1', '1', ''), ('61', '小清河', '530129001002008', 'area', '1', '8', '53', '1', '1', ''), ('62', '红果村委会', '530129001003', 'area', '1', '3', '38', '1', '1', ''), ('63', '大平地', '530129001003001', 'area', '1', '1', '62', '1', '1', ''), ('64', '陡嘴', '530129001003002', 'area', '1', '2', '62', '1', '1', ''), ('65', '红果', '530129001003003', 'area', '1', '3', '62', '1', '1', ''), ('66', '龙潭河', '530129001003004', 'area', '1', '4', '62', '1', '1', ''), ('67', '麻塘', '530129001003005', 'area', '1', '5', '62', '1', '1', ''), ('68', '新田', '530129001003006', 'area', '1', '6', '62', '1', '1', ''), ('69', '野鸭塘', '530129001003007', 'area', '1', '7', '62', '1', '1', ''), ('70', '老村村委会', '530129001004', 'area', '1', '4', '38', '1', '1', ''), ('71', '大河', '530129001004001', 'area', '1', '1', '70', '1', '1', ''), ('72', '大陷塘', '530129001004002', 'area', '1', '2', '70', '1', '1', ''), ('73', '老村', '530129001004003', 'area', '1', '3', '70', '1', '1', ''), ('74', '坡脚', '530129001004004', 'area', '1', '4', '70', '1', '1', ''), ('75', '新村', '530129001004005', 'area', '1', '5', '70', '1', '1', ''), ('76', '麦地心村委会', '530129001005', 'area', '1', '5', '38', '1', '1', ''), ('77', '百来乌', '530129001005001', 'area', '1', '1', '76', '1', '1', ''), ('78', '草海子', '530129001005002', 'area', '1', '2', '76', '1', '1', ''), ('79', '干海子', '530129001005003', 'area', '1', '3', '76', '1', '1', ''), ('80', '老村子', '530129001005004', 'area', '1', '4', '76', '1', '1', ''), ('81', '麦地心', '530129001005005', 'area', '1', '5', '76', '1', '1', ''), ('82', '沙必朗', '530129001005006', 'area', '1', '6', '76', '1', '1', ''), ('83', '双箐村', '530129001005007', 'area', '1', '7', '76', '1', '1', ''), ('84', '小水井', '530129001005008', 'area', '1', '8', '76', '1', '1', ''), ('85', '兴隆村委会', '530129001006', 'area', '1', '6', '38', '1', '1', ''), ('86', '菜子山', '530129001006001', 'area', '1', '1', '85', '1', '1', ''), ('87', '大斗乌', '530129001006002', 'area', '1', '2', '85', '1', '1', ''), ('88', '横山', '530129001006003', 'area', '1', '3', '85', '1', '1', ''), ('89', '六差冲', '530129001006004', 'area', '1', '4', '85', '1', '1', ''), ('90', '王家山', '530129001006005', 'area', '1', '5', '85', '1', '1', ''), ('91', '小冲冲', '530129001006006', 'area', '1', '6', '85', '1', '1', ''), ('92', '小冲子', '530129001006007', 'area', '1', '7', '85', '1', '1', ''), ('93', '治租村委会', '530129001007', 'area', '1', '7', '38', '1', '1', ''), ('94', '大治租', '530129001007001', 'area', '1', '1', '93', '1', '1', ''), ('95', '盘海箐', '530129001007002', 'area', '1', '2', '93', '1', '1', ''), ('96', '小治租', '530129001007003', 'area', '1', '3', '93', '1', '1', ''), ('97', '凤合镇', '530129002', 'area', '1', '2', '29', '1', '1', ''), ('98', '合理村委会', '530129002001', 'area', '1', '1', '97', '1', '1', ''), ('99', '啊世卡2社', '530129002001001', 'area', '1', '1', '98', '1', '1', ''), ('100', '啊世卡1社', '530129002001002', 'area', '1', '2', '98', '1', '1', ''), ('101', '大庆村委会', '530129002002', 'area', '1', '2', '97', '1', '1', ''), ('102', '龙潭', '530129002002001', 'area', '1', '1', '101', '1', '1', ''), ('103', '杉松哨村', '530129002002002', 'area', '1', '2', '101', '1', '1', ''), ('104', '集城村委会', '530129002003', 'area', '1', '3', '97', '1', '1', ''), ('105', '上昔卡里村', '530129002003001', 'area', '1', '1', '104', '1', '1', ''), ('106', '阿箐丹村', '530129002003002', 'area', '1', '2', '104', '1', '1', ''), ('107', '大书米丹村', '530129002003003', 'area', '1', '3', '104', '1', '1', ''), ('108', '噜咩村', '530129002003004', 'area', '1', '4', '104', '1', '1', ''), ('109', '旧军营村', '530129002003005', 'area', '1', '5', '104', '1', '1', ''), ('110', '多姑村委会', '530129002004', 'area', '1', '4', '97', '1', '1', ''), ('111', '茨姑地', '530129002004001', 'area', '1', '1', '110', '1', '1', ''), ('112', '绿因塘', '530129002004002', 'area', '1', '2', '110', '1', '1', ''), ('113', '小奢奢', '530129002004003', 'area', '1', '3', '110', '1', '1', ''), ('114', '马西多', '530129002004004', 'area', '1', '4', '110', '1', '1', ''), ('115', '积水村委会', '530129002005', 'area', '1', '5', '97', '1', '1', ''), ('116', '摆子嘎', '530129002005001', 'area', '1', '1', '115', '1', '1', ''), ('117', '龙池村委会', '530129002006', 'area', '1', '6', '97', '1', '1', ''), ('118', '小冲', '530129002006001', 'area', '1', '1', '117', '1', '1', ''), ('119', '发来古村委会', '530129002007', 'area', '1', '7', '97', '1', '1', ''), ('120', '发来古', '530129002007001', 'area', '1', '1', '119', '1', '1', ''), ('121', '老里凹', '530129002007002', 'area', '1', '2', '119', '1', '1', ''), ('122', '新城村委会', '530129002008', 'area', '1', '8', '97', '1', '1', ''), ('123', '瓦窑', '530129002008001', 'area', '1', '1', '122', '1', '1', ''), ('124', '大麦地村委会', '530129002009', 'area', '1', '9', '97', '1', '1', ''), ('125', '大麦地', '530129002009001', 'area', '1', '1', '124', '1', '1', ''), ('126', '驻基村委会', '5301290020010', 'area', '1', '10', '97', '1', '1', ''), ('127', '打场箐', '5301290020010001', 'area', '1', '1', '126', '1', '1', ''), ('128', '大村', '5301290020010002', 'area', '1', '2', '126', '1', '1', ''), ('129', '石头坡', '5301290020010003', 'area', '1', '3', '126', '1', '1', ''), ('130', '联合村委会', '5301290020011', 'area', '1', '11', '97', '1', '1', ''), ('131', '马店', '5301290020011001', 'area', '1', '1', '130', '1', '1', ''), ('132', '黑石岩', '5301290020011002', 'area', '1', '2', '130', '1', '1', ''), ('133', '白泥塘村', '5301290020011003', 'area', '1', '3', '130', '1', '1', ''), ('134', '新田村', '5301290020011004', 'area', '1', '4', '130', '1', '1', ''), ('135', '支利', '5301290020011005', 'area', '1', '5', '130', '1', '1', ''), ('136', '功山镇', '530129003', 'area', '1', '3', '29', '1', '1', ''), ('137', '白龙', '530129003001', 'area', '1', '1', '136', '1', '1', ''), ('138', '白龙村', '530129003001001', 'area', '1', '1', '137', '1', '1', ''), ('139', '白龙箐', '530129003001002', 'area', '1', '2', '137', '1', '1', ''), ('140', '苍卜塘', '530129003001003', 'area', '1', '3', '137', '1', '1', ''), ('141', '得胜坡', '530129003001004', 'area', '1', '4', '137', '1', '1', ''), ('142', '蚂蝗箐', '530129003001005', 'area', '1', '5', '137', '1', '1', ''), ('143', '纲纪', '530129003002', 'area', '1', '2', '136', '1', '1', ''), ('144', '大塘子', '530129003002001', 'area', '1', '1', '143', '1', '1', ''), ('145', '河湾冲', '530129003002002', 'area', '1', '2', '143', '1', '1', ''), ('146', '化香箐', '530129003002003', 'area', '1', '3', '143', '1', '1', ''), ('147', '蒲草塘', '530129003002004', 'area', '1', '4', '143', '1', '1', ''), ('148', '沙沟', '530129003002005', 'area', '1', '5', '143', '1', '1', ''), ('149', '水槽箐', '530129003002006', 'area', '1', '6', '143', '1', '1', ''), ('150', '湾地山', '530129003002007', 'area', '1', '7', '143', '1', '1', ''), ('151', '倘甸镇', '530129004', 'area', '1', '4', '29', '1', '1', ''), ('152', '功山', '530129004001', 'area', '1', '1', '151', '1', '1', ''), ('153', '镇横山二道沟', '530129004001001', 'area', '1', '1', '152', '1', '1', ''), ('154', '镇横山康复村', '530129004001002', 'area', '1', '2', '152', '1', '1', ''), ('155', '镇横山老房子', '530129004001003', 'area', '1', '3', '152', '1', '1', ''), ('156', '横山上', '530129003003', 'area', '1', '3', '136', '1', '1', ''), ('157', '村', '530129003003001', 'area', '1', '1', '156', '1', '1', ''), ('158', '镇横山桃园', '530129004001004', 'area', '1', '4', '152', '1', '1', ''), ('159', '镇横山下村', '530129004001005', 'area', '1', '5', '152', '1', '1', ''), ('160', '镇横山小横山', '530129004001006', 'area', '1', '6', '152', '1', '1', ''), ('161', '镇横山中村（横）', '530129004001007', 'area', '1', '7', '152', '1', '1', ''), ('162', '哨上', '530129003004', 'area', '1', '4', '136', '1', '1', ''), ('163', '大梨树', '530129003004001', 'area', '1', '1', '162', '1', '1', ''), ('164', '老头箐', '530129003004002', 'area', '1', '2', '162', '1', '1', ''), ('165', '上村（尹）', '530129003004003', 'area', '1', '3', '162', '1', '1', ''), ('166', '秧田冲（尹）', '530129003004004', 'area', '1', '4', '162', '1', '1', ''), ('167', '羊毛', '530129003005', 'area', '1', '5', '136', '1', '1', ''), ('168', '大石岩', '530129003005001', 'area', '1', '1', '167', '1', '1', ''), ('169', '高石岩', '530129003005002', 'area', '1', '2', '167', '1', '1', ''), ('170', '倪家村', '530129003005003', 'area', '1', '3', '167', '1', '1', ''), ('171', '羊毛冲', '530129003005004', 'area', '1', '4', '167', '1', '1', ''), ('172', '杨柳', '530129003006', 'area', '1', '6', '136', '1', '1', ''), ('173', '阿汪者', '530129003006001', 'area', '1', '1', '172', '1', '1', ''), ('174', '稻田坝', '530129003006002', 'area', '1', '2', '172', '1', '1', ''), ('175', '格来河北', '530129003006003', 'area', '1', '3', '172', '1', '1', ''), ('176', '杨柳格来上', '530129003007', 'area', '1', '7', '136', '1', '1', ''), ('177', '格来下村', '530129003006004', 'area', '1', '4', '172', '1', '1', ''), ('178', '龙街子', '530129003006005', 'area', '1', '5', '172', '1', '1', ''), ('179', '铜厂箐', '530129003006006', 'area', '1', '6', '172', '1', '1', ''), ('180', '杨柳村', '530129003006007', 'area', '1', '7', '172', '1', '1', ''), ('181', '竹园村', '530129003006008', 'area', '1', '8', '172', '1', '1', ''), ('182', '尹武', '530129003008', 'area', '1', '8', '136', '1', '1', ''), ('183', '川风洞', '530129003008001', 'area', '1', '1', '182', '1', '1', ''), ('184', '大水塘（尹）', '530129003008002', 'area', '1', '2', '182', '1', '1', ''), ('185', '撒米西', '530129003008003', 'area', '1', '3', '182', '1', '1', ''), ('186', '汪家坟', '530129003008004', 'area', '1', '4', '182', '1', '1', ''), ('187', '五里冲', '530129003008005', 'area', '1', '5', '182', '1', '1', ''), ('188', '云龙', '530129003009', 'area', '1', '9', '136', '1', '1', ''), ('189', '鲁家村', '530129003009001', 'area', '1', '1', '188', '1', '1', ''), ('190', '云龙上', '5301290030010', 'area', '1', '10', '136', '1', '1', ''), ('191', '村（云）', '5301290030010001', 'area', '1', '1', '190', '1', '1', ''), ('192', '梳山', '530129003009002', 'area', '1', '2', '188', '1', '1', ''), ('193', '云龙小石岩上', '5301290030011', 'area', '1', '11', '136', '1', '1', ''), ('194', '许家村', '530129003009003', 'area', '1', '3', '188', '1', '1', ''), ('195', '余家村', '530129003009004', 'area', '1', '4', '188', '1', '1', ''), ('196', '河口镇', '530129005', 'area', '1', '5', '29', '1', '1', ''), ('197', '白石岩村委会', '530129005001', 'area', '1', '1', '196', '1', '1', ''), ('198', '白泥塘', '530129005001001', 'area', '1', '1', '197', '1', '1', ''), ('199', '达连地', '530129005001002', 'area', '1', '2', '197', '1', '1', ''), ('200', '老房子', '530129005001003', 'area', '1', '3', '197', '1', '1', ''), ('201', '左口山', '530129005001004', 'area', '1', '4', '197', '1', '1', ''), ('202', '湾子1', '530129005001005', 'area', '1', '5', '197', '1', '1', ''), ('203', '深凹子', '530129005001006', 'area', '1', '6', '197', '1', '1', ''), ('204', '白石岩', '530129005001007', 'area', '1', '7', '197', '1', '1', ''), ('205', '干河', '530129005001008', 'area', '1', '8', '197', '1', '1', ''), ('206', '北大营村委会', '530129005002', 'area', '1', '2', '196', '1', '1', ''), ('207', '北大营', '530129005002001', 'area', '1', '1', '206', '1', '1', ''), ('208', '糯咩哨二', '530129005002002', 'area', '1', '2', '206', '1', '1', ''), ('209', '花沟上', '530129005002003', 'area', '1', '3', '206', '1', '1', ''), ('210', '糯咩哨一', '530129005002004', 'area', '1', '4', '206', '1', '1', ''), ('211', '大丫口', '530129005002005', 'area', '1', '5', '206', '1', '1', ''), ('212', '邓家村', '530129005002006', 'area', '1', '6', '206', '1', '1', ''), ('213', '尖山1', '530129005002007', 'area', '1', '7', '206', '1', '1', ''), ('214', '花沟下', '530129005002008', 'area', '1', '8', '206', '1', '1', ''), ('215', '石板河', '530129005002009', 'area', '1', '9', '206', '1', '1', ''), ('216', '东瓜岭', '5301290050020010', 'area', '1', '10', '206', '1', '1', ''), ('217', '十八车', '5301290050020011', 'area', '1', '11', '206', '1', '1', ''), ('218', '海嘎村委会', '530129005003', 'area', '1', '3', '196', '1', '1', ''), ('219', '竹园沟二', '530129005003001', 'area', '1', '1', '218', '1', '1', ''), ('220', '白龙潭', '530129005003002', 'area', '1', '2', '218', '1', '1', ''), ('221', '黑脸田', '530129005003003', 'area', '1', '3', '218', '1', '1', ''), ('222', '小坪子三', '530129005003004', 'area', '1', '4', '218', '1', '1', ''), ('223', '大坪子', '530129005003005', 'area', '1', '5', '218', '1', '1', ''), ('224', '小坪子一', '530129005003006', 'area', '1', '6', '218', '1', '1', ''), ('225', '小坪子二', '530129005003007', 'area', '1', '7', '218', '1', '1', ''), ('226', '诺嘎一', '530129005003008', 'area', '1', '8', '218', '1', '1', ''), ('227', '河底', '530129005003009', 'area', '1', '9', '218', '1', '1', ''), ('228', '李子树一', '5301290050030010', 'area', '1', '10', '218', '1', '1', ''), ('229', '小村一', '5301290050030011', 'area', '1', '11', '218', '1', '1', ''), ('230', '李子树二', '5301290050030012', 'area', '1', '12', '218', '1', '1', ''), ('231', '竹园沟一', '5301290050030013', 'area', '1', '13', '218', '1', '1', ''), ('232', '小坪子四', '5301290050030014', 'area', '1', '14', '218', '1', '1', ''), ('233', '瓦房上', '5301290050030015', 'area', '1', '15', '218', '1', '1', ''), ('234', '黑箐村委会', '530129005004', 'area', '1', '4', '196', '1', '1', ''), ('235', '大箐2', '530129005004001', 'area', '1', '1', '234', '1', '1', ''), ('236', '梅子箐', '530129005004002', 'area', '1', '2', '234', '1', '1', ''), ('237', '黑箐二', '530129005004003', 'area', '1', '3', '234', '1', '1', ''), ('238', '黑箐一', '530129005004004', 'area', '1', '4', '234', '1', '1', ''), ('239', '老场', '530129005004005', 'area', '1', '5', '234', '1', '1', ''), ('240', '大地', '530129005004006', 'area', '1', '6', '234', '1', '1', ''), ('241', '白沙坡', '530129005004007', 'area', '1', '7', '234', '1', '1', ''), ('242', '大山', '530129005004008', 'area', '1', '8', '234', '1', '1', ''), ('243', '核桃树', '530129005004009', 'area', '1', '9', '234', '1', '1', ''), ('244', '旧黑箐', '5301290050040010', 'area', '1', '10', '234', '1', '1', ''), ('245', '小坡', '5301290050040011', 'area', '1', '11', '234', '1', '1', ''), ('246', '木龙照', '5301290050040012', 'area', '1', '12', '234', '1', '1', ''), ('247', '化桃箐村委会', '530129005005', 'area', '1', '5', '196', '1', '1', ''), ('248', '竹园一', '530129005005001', 'area', '1', '1', '247', '1', '1', ''), ('249', '水节', '530129005005002', 'area', '1', '2', '247', '1', '1', ''), ('250', '竹园二', '530129005005003', 'area', '1', '3', '247', '1', '1', ''), ('251', '化桃箐一', '530129005005004', 'area', '1', '4', '247', '1', '1', ''), ('252', '礼拜寺', '530129005005005', 'area', '1', '5', '247', '1', '1', ''), ('253', '新桥', '530129005005006', 'area', '1', '6', '247', '1', '1', ''), ('254', '竹园三', '530129005005007', 'area', '1', '7', '247', '1', '1', ''), ('255', '化桃箐二', '530129005005008', 'area', '1', '8', '247', '1', '1', ''), ('256', '新平', '530129005005009', 'area', '1', '9', '247', '1', '1', ''), ('257', '走马平', '5301290050050010', 'area', '1', '10', '247', '1', '1', ''), ('258', '鲁冲村委会', '530129005006', 'area', '1', '6', '196', '1', '1', ''), ('259', '马路坡', '530129005006001', 'area', '1', '1', '258', '1', '1', ''), ('260', '三村1', '530129005006002', 'area', '1', '2', '258', '1', '1', ''), ('261', '小村1', '530129005006003', 'area', '1', '3', '258', '1', '1', ''), ('262', '上村1', '530129005006004', 'area', '1', '4', '258', '1', '1', ''), ('263', '水淹田', '530129005006005', 'area', '1', '5', '258', '1', '1', ''), ('264', '下古厂', '530129005006006', 'area', '1', '6', '258', '1', '1', ''), ('265', '三华山', '530129005006007', 'area', '1', '7', '258', '1', '1', ''), ('266', '长房子1', '530129005006008', 'area', '1', '8', '258', '1', '1', ''), ('267', '小桥', '530129005006009', 'area', '1', '9', '258', '1', '1', ''), ('268', '大箐', '5301290050060010', 'area', '1', '10', '258', '1', '1', ''), ('269', '老村1', '5301290050060011', 'area', '1', '11', '258', '1', '1', ''), ('270', '小龙潭', '5301290050060012', 'area', '1', '12', '258', '1', '1', ''), ('271', '石则地', '5301290050060013', 'area', '1', '13', '258', '1', '1', ''), ('272', '鲁撒格村委会', '530129005007', 'area', '1', '7', '196', '1', '1', ''), ('273', '石头嘴', '530129005007001', 'area', '1', '1', '272', '1', '1', ''), ('274', '良子', '530129005007002', 'area', '1', '2', '272', '1', '1', ''), ('275', '鲁五小组', '530129005007003', 'area', '1', '3', '272', '1', '1', ''), ('276', '鲁三小组', '530129005007004', 'area', '1', '4', '272', '1', '1', ''), ('277', '陆柴冲', '530129005007005', 'area', '1', '5', '272', '1', '1', ''), ('278', '大箐1', '530129005007006', 'area', '1', '6', '272', '1', '1', ''), ('279', '鲁四小组', '530129005007007', 'area', '1', '7', '272', '1', '1', ''), ('280', '鲁一小组', '530129005007008', 'area', '1', '8', '272', '1', '1', ''), ('281', '鲁二小组', '530129005007009', 'area', '1', '9', '272', '1', '1', ''), ('282', '庄房', '5301290050070010', 'area', '1', '10', '272', '1', '1', ''), ('283', '米德卡村委会', '530129005008', 'area', '1', '8', '196', '1', '1', ''), ('284', '小汤姑', '530129005008001', 'area', '1', '1', '283', '1', '1', ''), ('285', '扁石洞上', '530129005008002', 'area', '1', '2', '283', '1', '1', ''), ('286', '新发', '530129005008003', 'area', '1', '3', '283', '1', '1', ''), ('287', '米德卡', '530129005008004', 'area', '1', '4', '283', '1', '1', ''), ('288', '扁石洞下', '530129005008005', 'area', '1', '5', '283', '1', '1', ''), ('289', '华石砍', '530129005008006', 'area', '1', '6', '283', '1', '1', ''), ('290', '金家冲下', '530129005008007', 'area', '1', '7', '283', '1', '1', ''), ('291', '牛黄冲', '530129005008008', 'area', '1', '8', '283', '1', '1', ''), ('292', '金家冲上', '530129005008009', 'area', '1', '9', '283', '1', '1', ''), ('293', '糯基村委会', '530129005009', 'area', '1', '9', '196', '1', '1', ''), ('294', '糯基', '530129005009001', 'area', '1', '1', '293', '1', '1', ''), ('295', '象鼻岭', '530129005009002', 'area', '1', '2', '293', '1', '1', ''), ('296', '青麦地', '530129005009003', 'area', '1', '3', '293', '1', '1', ''), ('297', '回龙潭', '530129005009004', 'area', '1', '4', '293', '1', '1', ''), ('298', '写字塘', '530129005009005', 'area', '1', '5', '293', '1', '1', ''), ('299', '下坝口', '530129005009006', 'area', '1', '6', '293', '1', '1', ''), ('300', '撒米落村委会', '5301290050010', 'area', '1', '10', '196', '1', '1', ''), ('301', '长房子', '5301290050010001', 'area', '1', '1', '300', '1', '1', ''), ('302', '上村', '5301290050010002', 'area', '1', '2', '300', '1', '1', ''), ('303', '羊场', '5301290050010003', 'area', '1', '3', '300', '1', '1', ''), ('304', '楼房', '5301290050010004', 'area', '1', '4', '300', '1', '1', ''), ('305', '大坪子1', '5301290050010005', 'area', '1', '5', '300', '1', '1', ''), ('306', '小坪子', '5301290050010006', 'area', '1', '6', '300', '1', '1', ''), ('307', '金家村', '5301290050010007', 'area', '1', '7', '300', '1', '1', ''), ('308', '大村子', '5301290050010008', 'area', '1', '8', '300', '1', '1', ''), ('309', '山被后', '5301290050010009', 'area', '1', '9', '300', '1', '1', ''), ('310', '沙谷渡村委会', '5301290050011', 'area', '1', '11', '196', '1', '1', ''), ('311', '座鸟', '5301290050011001', 'area', '1', '1', '310', '1', '1', ''), ('312', '新村1', '5301290050011002', 'area', '1', '2', '310', '1', '1', ''), ('313', '旧村', '5301290050011003', 'area', '1', '3', '310', '1', '1', ''), ('314', '小村', '5301290050011004', 'area', '1', '4', '310', '1', '1', ''), ('315', '三塘', '5301290050011005', 'area', '1', '5', '310', '1', '1', ''), ('316', '白龙潭1', '5301290050011006', 'area', '1', '6', '310', '1', '1', ''), ('317', '十甲村委会', '5301290050012', 'area', '1', '12', '196', '1', '1', ''), ('318', '石槽子', '5301290050012001', 'area', '1', '1', '317', '1', '1', ''), ('319', '大树良子', '5301290050012002', 'area', '1', '2', '317', '1', '1', ''), ('320', '小竹箐', '5301290050012003', 'area', '1', '3', '317', '1', '1', ''), ('321', '下打吾', '5301290050012004', 'area', '1', '4', '317', '1', '1', ''), ('322', '磨浪姑', '5301290050012005', 'area', '1', '5', '317', '1', '1', ''), ('323', '上打吾', '5301290050012006', 'area', '1', '6', '317', '1', '1', ''), ('324', '此马力', '5301290050012007', 'area', '1', '7', '317', '1', '1', ''), ('325', '小水塘', '5301290050012008', 'area', '1', '8', '317', '1', '1', ''), ('326', '长坡', '5301290050012009', 'area', '1', '9', '317', '1', '1', ''), ('327', '小街', '53012900500120010', 'area', '1', '10', '317', '1', '1', ''), ('328', '大竹箐', '53012900500120011', 'area', '1', '11', '317', '1', '1', ''), ('329', '青沙坡', '53012900500120012', 'area', '1', '12', '317', '1', '1', ''), ('330', '楼房1', '53012900500120013', 'area', '1', '13', '317', '1', '1', ''), ('331', '大坪地', '53012900500120014', 'area', '1', '14', '317', '1', '1', ''), ('332', '窑弯子', '53012900500120015', 'area', '1', '15', '317', '1', '1', ''), ('333', '双龙村委会', '5301290050013', 'area', '1', '13', '196', '1', '1', ''), ('334', '尖山', '5301290050013001', 'area', '1', '1', '333', '1', '1', ''), ('335', '老街子', '5301290050013002', 'area', '1', '2', '333', '1', '1', ''), ('336', '大水井', '5301290050013003', 'area', '1', '3', '333', '1', '1', ''), ('337', '毛荒田', '5301290050013004', 'area', '1', '4', '333', '1', '1', ''), ('338', '偏坡路', '5301290050013005', 'area', '1', '5', '333', '1', '1', ''), ('339', '干水塘', '5301290050013006', 'area', '1', '6', '333', '1', '1', ''), ('340', '白沙水', '5301290050013007', 'area', '1', '7', '333', '1', '1', ''), ('341', '猴子洞', '5301290050013008', 'area', '1', '8', '333', '1', '1', ''), ('342', '白草皮', '5301290050013009', 'area', '1', '9', '333', '1', '1', ''), ('343', '水冒田村委会', '5301290050014', 'area', '1', '14', '196', '1', '1', ''), ('344', '朵莫', '5301290050014001', 'area', '1', '1', '343', '1', '1', ''), ('345', '鲁纳', '5301290050014002', 'area', '1', '2', '343', '1', '1', ''), ('346', '半坡', '5301290050014003', 'area', '1', '3', '343', '1', '1', ''), ('347', '小米田', '5301290050014004', 'area', '1', '4', '343', '1', '1', ''), ('348', '水冒田', '5301290050014005', 'area', '1', '5', '343', '1', '1', ''), ('349', '紧风口', '5301290050014006', 'area', '1', '6', '343', '1', '1', ''), ('350', '大山1', '5301290050014007', 'area', '1', '7', '343', '1', '1', ''), ('351', '小街村委会', '5301290050015', 'area', '1', '15', '196', '1', '1', ''), ('352', '糟家湾', '5301290050015001', 'area', '1', '1', '351', '1', '1', ''), ('353', '大地埂', '5301290050015002', 'area', '1', '2', '351', '1', '1', ''), ('354', '恩格', '5301290050015003', 'area', '1', '3', '351', '1', '1', ''), ('355', '小街1', '5301290050015004', 'area', '1', '4', '351', '1', '1', ''), ('356', '阿基塘', '5301290050015005', 'area', '1', '5', '351', '1', '1', ''), ('357', '二半山箐田', '5301290050015006', 'area', '1', '6', '351', '1', '1', ''), ('358', '长家坝', '5301290050015007', 'area', '1', '7', '351', '1', '1', ''), ('359', '石洞门', '5301290050015008', 'area', '1', '8', '351', '1', '1', ''), ('360', '金发', '5301290050015009', 'area', '1', '9', '351', '1', '1', ''), ('361', '啊那法', '53012900500150010', 'area', '1', '10', '351', '1', '1', ''), ('362', '云河村委会', '5301290050016', 'area', '1', '16', '196', '1', '1', ''), ('363', '大云', '5301290050016001', 'area', '1', '1', '362', '1', '1', ''), ('364', '半山', '5301290050016002', 'area', '1', '2', '362', '1', '1', ''), ('365', '旧云', '5301290050016003', 'area', '1', '3', '362', '1', '1', ''), ('366', '窑房二组', '5301290050016004', 'area', '1', '4', '362', '1', '1', ''), ('367', '稍基凹', '5301290050016005', 'area', '1', '5', '362', '1', '1', ''), ('368', '湾子', '5301290050016006', 'area', '1', '6', '362', '1', '1', ''), ('369', '庄子', '5301290050016007', 'area', '1', '7', '362', '1', '1', ''), ('370', '围赶坡', '5301290050016008', 'area', '1', '8', '362', '1', '1', ''), ('371', '河口', '5301290050016009', 'area', '1', '9', '362', '1', '1', ''), ('372', '窑房一组', '53012900500160010', 'area', '1', '10', '362', '1', '1', ''), ('373', '鸡街镇', '530129006', 'area', '1', '6', '29', '1', '1', ''), ('374', '北屏村委会', '530129006001', 'area', '1', '1', '373', '1', '1', ''), ('375', '卧间', '530129006001001', 'area', '1', '1', '374', '1', '1', ''), ('376', '以则宽', '530129006001002', 'area', '1', '2', '374', '1', '1', ''), ('377', '余家庆', '530129006001003', 'area', '1', '3', '374', '1', '1', ''), ('378', '抓地龙', '530129006001004', 'area', '1', '4', '374', '1', '1', ''), ('379', '彩已村委会', '530129006002', 'area', '1', '2', '373', '1', '1', ''), ('380', '彩已八社', '530129006002001', 'area', '1', '1', '379', '1', '1', ''), ('381', '彩已二社', '530129006002002', 'area', '1', '2', '379', '1', '1', ''), ('382', '彩已九社', '530129006002003', 'area', '1', '3', '379', '1', '1', ''), ('383', '彩已六社', '530129006002004', 'area', '1', '4', '379', '1', '1', ''), ('384', '彩已七社', '530129006002005', 'area', '1', '5', '379', '1', '1', ''), ('385', '彩已三社', '530129006002006', 'area', '1', '6', '379', '1', '1', ''), ('386', '彩已四社', '530129006002007', 'area', '1', '7', '379', '1', '1', ''), ('387', '彩已五社', '530129006002008', 'area', '1', '8', '379', '1', '1', ''), ('388', '彩已一社', '530129006002009', 'area', '1', '9', '379', '1', '1', ''), ('389', '耻格村委会', '530129006003', 'area', '1', '3', '373', '1', '1', ''), ('390', '耻格二社', '530129006003001', 'area', '1', '1', '389', '1', '1', ''), ('391', '耻格六社', '530129006003002', 'area', '1', '2', '389', '1', '1', ''), ('392', '耻格三社', '530129006003003', 'area', '1', '3', '389', '1', '1', ''), ('393', '耻格四社', '530129006003004', 'area', '1', '4', '389', '1', '1', ''), ('394', '耻格五社', '530129006003005', 'area', '1', '5', '389', '1', '1', ''), ('395', '耻格一社', '530129006003006', 'area', '1', '6', '389', '1', '1', ''), ('396', '古城村委会', '530129006004', 'area', '1', '4', '373', '1', '1', ''), ('397', '古城二社', '530129006004001', 'area', '1', '1', '396', '1', '1', ''), ('398', '古城六社', '530129006004002', 'area', '1', '2', '396', '1', '1', ''), ('399', '古城三社', '530129006004003', 'area', '1', '3', '396', '1', '1', ''), ('400', '古城四社', '530129006004004', 'area', '1', '4', '396', '1', '1', ''), ('401', '古城五社', '530129006004005', 'area', '1', '5', '396', '1', '1', ''), ('402', '古城一社', '530129006004006', 'area', '1', '6', '396', '1', '1', ''), ('403', '黑山村委会', '530129006005', 'area', '1', '5', '373', '1', '1', ''), ('404', '黑山二社', '530129006005001', 'area', '1', '1', '403', '1', '1', ''), ('405', '黑山五社', '530129006005002', 'area', '1', '2', '403', '1', '1', ''), ('406', '黑山一社', '530129006005003', 'area', '1', '3', '403', '1', '1', ''), ('407', '鸡街村委会', '530129006006', 'area', '1', '6', '373', '1', '1', ''), ('408', '鸡街八社', '530129006006001', 'area', '1', '1', '407', '1', '1', ''), ('409', '鸡街二社', '530129006006002', 'area', '1', '2', '407', '1', '1', ''), ('410', '鸡街九社', '530129006006003', 'area', '1', '3', '407', '1', '1', ''), ('411', '鸡街六社', '530129006006004', 'area', '1', '4', '407', '1', '1', ''), ('412', '鸡街七社', '530129006006005', 'area', '1', '5', '407', '1', '1', ''), ('413', '鸡街三社', '530129006006006', 'area', '1', '6', '407', '1', '1', ''), ('414', '鸡街十社', '530129006006007', 'area', '1', '7', '407', '1', '1', ''), ('415', '鸡街十一社', '530129006006008', 'area', '1', '8', '407', '1', '1', ''), ('416', '鸡街四社', '530129006006009', 'area', '1', '9', '407', '1', '1', ''), ('417', '鸡街五社', '5301290060060010', 'area', '1', '10', '407', '1', '1', ''), ('418', '鸡街一社', '5301290060060011', 'area', '1', '11', '407', '1', '1', ''), ('419', '吉乐村委会', '530129006007', 'area', '1', '7', '373', '1', '1', ''), ('420', '吉乐八社', '530129006007001', 'area', '1', '1', '419', '1', '1', ''), ('421', '吉乐二社', '530129006007002', 'area', '1', '2', '419', '1', '1', ''), ('422', '吉乐六社', '530129006007003', 'area', '1', '3', '419', '1', '1', ''), ('423', '吉乐七社', '530129006007004', 'area', '1', '4', '419', '1', '1', ''), ('424', '吉乐三社', '530129006007005', 'area', '1', '5', '419', '1', '1', ''), ('425', '吉乐四社', '530129006007006', 'area', '1', '6', '419', '1', '1', ''), ('426', '吉乐五社', '530129006007007', 'area', '1', '7', '419', '1', '1', ''), ('427', '吉乐一社', '530129006007008', 'area', '1', '8', '419', '1', '1', ''), ('428', '南海村委会', '530129006008', 'area', '1', '8', '373', '1', '1', ''), ('429', '南海八社', '530129006008001', 'area', '1', '1', '428', '1', '1', ''), ('430', '南海二社', '530129006008002', 'area', '1', '2', '428', '1', '1', ''), ('431', '南海九社', '530129006008003', 'area', '1', '3', '428', '1', '1', ''), ('432', '南海六社', '530129006008004', 'area', '1', '4', '428', '1', '1', ''), ('433', '南海七社', '530129006008005', 'area', '1', '5', '428', '1', '1', ''), ('434', '南海三社', '530129006008006', 'area', '1', '6', '428', '1', '1', ''), ('435', '南海十二社', '530129006008007', 'area', '1', '7', '428', '1', '1', ''), ('436', '南海十三社', '530129006008008', 'area', '1', '8', '428', '1', '1', ''), ('437', '南海十社', '530129006008009', 'area', '1', '9', '428', '1', '1', ''), ('438', '南海十一社', '5301290060080010', 'area', '1', '10', '428', '1', '1', ''), ('439', '南海四社', '5301290060080011', 'area', '1', '11', '428', '1', '1', ''), ('440', '南海五社', '5301290060080012', 'area', '1', '12', '428', '1', '1', ''), ('441', '南海一社', '5301290060080013', 'area', '1', '13', '428', '1', '1', ''), ('442', '四哨村委会', '530129006009', 'area', '1', '9', '373', '1', '1', ''), ('443', '四哨二社', '530129006009001', 'area', '1', '1', '442', '1', '1', ''), ('444', '四哨三社', '530129006009002', 'area', '1', '2', '442', '1', '1', ''), ('445', '四哨一社', '530129006009003', 'area', '1', '3', '442', '1', '1', ''), ('446', '拖姑村委会', '5301290060010', 'area', '1', '10', '373', '1', '1', ''), ('447', '拖姑二社', '5301290060010001', 'area', '1', '1', '446', '1', '1', ''), ('448', '拖姑三社', '5301290060010002', 'area', '1', '2', '446', '1', '1', ''), ('449', '拖姑四社', '5301290060010003', 'area', '1', '3', '446', '1', '1', ''), ('450', '拖姑五社', '5301290060010004', 'area', '1', '4', '446', '1', '1', ''), ('451', '拖姑一社', '5301290060010005', 'area', '1', '5', '446', '1', '1', ''), ('452', '泽和村委会', '5301290060011', 'area', '1', '11', '373', '1', '1', ''), ('453', '泽和八社', '5301290060011001', 'area', '1', '1', '452', '1', '1', ''), ('454', '泽和二社', '5301290060011002', 'area', '1', '2', '452', '1', '1', ''), ('455', '泽和九社', '5301290060011003', 'area', '1', '3', '452', '1', '1', ''), ('456', '泽和六社', '5301290060011004', 'area', '1', '4', '452', '1', '1', ''), ('457', '泽和七社', '5301290060011005', 'area', '1', '5', '452', '1', '1', ''), ('458', '泽和三社', '5301290060011006', 'area', '1', '6', '452', '1', '1', ''), ('459', '泽和十社', '5301290060011007', 'area', '1', '7', '452', '1', '1', ''), ('460', '泽和四社', '5301290060011008', 'area', '1', '8', '452', '1', '1', ''), ('461', '泽和五社', '5301290060011009', 'area', '1', '9', '452', '1', '1', ''), ('462', '泽和一社', '53012900600110010', 'area', '1', '10', '452', '1', '1', ''), ('463', '金所乡', '530129007', 'area', '1', '7', '29', '1', '1', ''), ('464', '摆宰村委会', '530129007001', 'area', '1', '1', '463', '1', '1', ''), ('465', '摆宰村', '530129007001001', 'area', '1', '1', '464', '1', '1', ''), ('466', '天生村委会', '530129007002', 'area', '1', '2', '463', '1', '1', ''), ('467', '白家哨', '530129007002001', 'area', '1', '1', '466', '1', '1', ''), ('468', '发祖屋', '530129007002002', 'area', '1', '2', '466', '1', '1', ''), ('469', '张所村委会', '530129007003', 'area', '1', '3', '463', '1', '1', ''), ('470', '排秋村', '530129007003001', 'area', '1', '1', '469', '1', '1', ''), ('471', '张所大村', '530129007003002', 'area', '1', '2', '469', '1', '1', ''), ('472', '张所小村', '530129007003003', 'area', '1', '3', '469', '1', '1', ''), ('473', '水沟村', '530129007003004', 'area', '1', '4', '469', '1', '1', ''), ('474', '竹沟村委会', '530129007004', 'area', '1', '4', '463', '1', '1', ''), ('475', '魏所村', '530129007004001', 'area', '1', '1', '474', '1', '1', ''), ('476', '新庄村', '530129007004002', 'area', '1', '2', '474', '1', '1', ''), ('477', '竹沟村', '530129007004003', 'area', '1', '3', '474', '1', '1', ''), ('478', '泽铁村委会', '530129007005', 'area', '1', '5', '463', '1', '1', ''), ('479', '麦冲村', '530129007005001', 'area', '1', '1', '478', '1', '1', ''), ('480', '栽开1社', '530129007005002', 'area', '1', '2', '478', '1', '1', ''), ('481', '栽开2社', '530129007005003', 'area', '1', '3', '478', '1', '1', ''), ('482', '金所村委会', '530129007006', 'area', '1', '6', '463', '1', '1', ''), ('483', '金所村', '530129007006001', 'area', '1', '1', '482', '1', '1', ''), ('484', '潘所村', '530129007006002', 'area', '1', '2', '482', '1', '1', ''), ('485', '金源乡', '530129008', 'area', '1', '8', '29', '1', '1', ''), ('486', '安丰村委会', '530129008001', 'area', '1', '1', '485', '1', '1', ''), ('487', '安丰村', '530129008001001', 'area', '1', '1', '486', '1', '1', ''), ('488', '大刺棚', '530129008001002', 'area', '1', '2', '486', '1', '1', ''), ('489', '大河边', '530129008001003', 'area', '1', '3', '486', '1', '1', ''), ('490', '耗子龙', '530129008001004', 'area', '1', '4', '486', '1', '1', ''), ('491', '瓦窑村', '530129008001005', 'area', '1', '5', '486', '1', '1', ''), ('492', '安秧村委会', '530129008002', 'area', '1', '2', '485', '1', '1', ''), ('493', '安秧村', '530129008002001', 'area', '1', '1', '492', '1', '1', ''), ('494', '槽子上', '530129008002002', 'area', '1', '2', '492', '1', '1', ''), ('495', '荒田三社', '530129008002003', 'area', '1', '3', '492', '1', '1', ''), ('496', '张家村', '530129008002004', 'area', '1', '4', '492', '1', '1', ''), ('497', '金源村委会', '530129008003', 'area', '1', '3', '485', '1', '1', ''), ('498', '半山村', '530129008003001', 'area', '1', '1', '497', '1', '1', ''), ('499', '大坡头', '530129008003002', 'area', '1', '2', '497', '1', '1', ''), ('500', '老街村', '530129008003003', 'area', '1', '3', '497', '1', '1', ''), ('501', '瓦房村委会', '530129008004', 'area', '1', '4', '485', '1', '1', ''), ('502', '梁子上', '530129008004001', 'area', '1', '1', '501', '1', '1', ''), ('503', '瓦房村', '530129008004002', 'area', '1', '2', '501', '1', '1', ''), ('504', '小村村委会', '530129008005', 'area', '1', '5', '485', '1', '1', ''), ('505', '马槽坑', '530129008005001', 'area', '1', '1', '504', '1', '1', ''), ('506', '柯渡镇', '530129009', 'area', '1', '9', '29', '1', '1', ''), ('507', '磨腮村委会', '530129009001', 'area', '1', '1', '506', '1', '1', ''), ('508', '仙人洞', '530129009001001', 'area', '1', '1', '507', '1', '1', ''), ('509', '租嘎', '530129009001002', 'area', '1', '2', '507', '1', '1', ''), ('510', '租则阱', '530129009001003', 'area', '1', '3', '507', '1', '1', ''), ('511', '以村', '530129009001004', 'area', '1', '4', '507', '1', '1', ''), ('512', '外村', '530129009001005', 'area', '1', '5', '507', '1', '1', ''), ('513', '里交嘎', '530129009001006', 'area', '1', '6', '507', '1', '1', ''), ('514', '小桃树', '530129009001007', 'area', '1', '7', '507', '1', '1', ''), ('515', '山万鲁', '530129009001008', 'area', '1', '8', '507', '1', '1', ''), ('516', '磨腮村', '530129009001009', 'area', '1', '9', '507', '1', '1', ''), ('517', '马庄', '5301290090010010', 'area', '1', '10', '507', '1', '1', ''), ('518', '落尔阱', '5301290090010011', 'area', '1', '11', '507', '1', '1', ''), ('519', '高田', '5301290090010012', 'area', '1', '12', '507', '1', '1', ''), ('520', '小石洞', '5301290090010013', 'area', '1', '13', '507', '1', '1', ''), ('521', '可郎村委会', '530129009002', 'area', '1', '2', '506', '1', '1', ''), ('522', '一组', '530129009002001', 'area', '1', '1', '521', '1', '1', ''), ('523', '二组', '530129009002002', 'area', '1', '2', '521', '1', '1', ''), ('524', '三组', '530129009002003', 'area', '1', '3', '521', '1', '1', ''), ('525', '四组', '530129009002004', 'area', '1', '4', '521', '1', '1', ''), ('526', '五组', '530129009002005', 'area', '1', '5', '521', '1', '1', ''), ('527', '七组', '530129009002006', 'area', '1', '6', '521', '1', '1', ''), ('528', '九组', '530129009002007', 'area', '1', '7', '521', '1', '1', ''), ('529', '十组', '530129009002008', 'area', '1', '8', '521', '1', '1', ''), ('530', '十二组', '530129009002009', 'area', '1', '9', '521', '1', '1', ''), ('531', '十三组', '5301290090020010', 'area', '1', '10', '521', '1', '1', ''), ('532', '十四组', '5301290090020011', 'area', '1', '11', '521', '1', '1', ''), ('533', '十五组', '5301290090020012', 'area', '1', '12', '521', '1', '1', ''), ('534', '十六组', '5301290090020013', 'area', '1', '13', '521', '1', '1', ''), ('535', '十七组', '5301290090020014', 'area', '1', '14', '521', '1', '1', ''), ('536', '新沙村委会', '530129009003', 'area', '1', '3', '506', '1', '1', ''), ('537', '白牡丹', '530129009003001', 'area', '1', '1', '536', '1', '1', ''), ('538', '沙庄', '530129009003002', 'area', '1', '2', '536', '1', '1', ''), ('539', '落塘', '530129009003003', 'area', '1', '3', '536', '1', '1', ''), ('540', '马茨塘', '530129009003004', 'area', '1', '4', '536', '1', '1', ''), ('541', '上沙朗', '530129009003005', 'area', '1', '5', '536', '1', '1', ''), ('542', '下沙朗', '530129009003006', 'area', '1', '6', '536', '1', '1', ''), ('543', '猴街村委会', '530129009004', 'area', '1', '4', '506', '1', '1', ''), ('544', '杉高树', '530129009004001', 'area', '1', '1', '543', '1', '1', ''), ('545', '黄力弯', '530129009004002', 'area', '1', '2', '543', '1', '1', ''), ('546', '三岔角', '530129009004003', 'area', '1', '3', '543', '1', '1', ''), ('547', '坡头', '530129009004004', 'area', '1', '4', '543', '1', '1', ''), ('548', '落木哨', '530129009004005', 'area', '1', '5', '543', '1', '1', ''), ('549', '三转弯', '530129009004006', 'area', '1', '6', '543', '1', '1', ''), ('550', '板田', '530129009004007', 'area', '1', '7', '543', '1', '1', ''), ('551', '新庄村委会', '530129009005', 'area', '1', '5', '506', '1', '1', ''), ('552', '花麦地', '530129009005001', 'area', '1', '1', '551', '1', '1', ''), ('553', '土木山', '530129009005002', 'area', '1', '2', '551', '1', '1', ''), ('554', '垭口', '530129009005003', 'area', '1', '3', '551', '1', '1', ''), ('555', '乐朗村委会', '530129009006', 'area', '1', '6', '506', '1', '1', ''), ('556', '发宝箐', '530129009006001', 'area', '1', '1', '555', '1', '1', ''), ('557', '三元井', '530129009006002', 'area', '1', '2', '555', '1', '1', ''), ('558', '白土克', '530129009006003', 'area', '1', '3', '555', '1', '1', ''), ('559', '新发村', '530129009006004', 'area', '1', '4', '555', '1', '1', ''), ('560', '肥草箐', '530129009006005', 'area', '1', '5', '555', '1', '1', ''), ('561', '乐朗二组', '530129009006006', 'area', '1', '6', '555', '1', '1', ''), ('562', '乐朗四组', '530129009006007', 'area', '1', '7', '555', '1', '1', ''), ('563', '小河箐', '530129009006008', 'area', '1', '8', '555', '1', '1', ''), ('564', '乐朗三组', '530129009006009', 'area', '1', '9', '555', '1', '1', ''), ('565', '乐朗一组', '5301290090060010', 'area', '1', '10', '555', '1', '1', ''), ('566', '多衣箐', '5301290090060011', 'area', '1', '11', '555', '1', '1', ''), ('567', '三井水', '5301290090060012', 'area', '1', '12', '555', '1', '1', ''), ('568', '浑水塘', '5301290090060013', 'area', '1', '13', '555', '1', '1', ''), ('569', '稗子田', '5301290090060014', 'area', '1', '14', '555', '1', '1', ''), ('570', '新村村委会', '530129009007', 'area', '1', '7', '506', '1', '1', ''), ('571', '白沙坡村', '530129009007001', 'area', '1', '1', '570', '1', '1', ''), ('572', '大俺村', '530129009007002', 'area', '1', '2', '570', '1', '1', ''), ('573', '小俺村', '530129009007003', 'area', '1', '3', '570', '1', '1', ''), ('574', '山猱', '530129009007004', 'area', '1', '4', '570', '1', '1', ''), ('575', '杨柳箐', '530129009007005', 'area', '1', '5', '570', '1', '1', ''), ('576', '松林村委会', '530129009008', 'area', '1', '8', '506', '1', '1', ''), ('577', '乔街哨', '530129009008001', 'area', '1', '1', '576', '1', '1', ''), ('578', '大黑箐', '530129009008002', 'area', '1', '2', '576', '1', '1', ''), ('579', '发罗', '530129009008003', 'area', '1', '3', '576', '1', '1', ''), ('580', '小陷塘', '530129009008004', 'area', '1', '4', '576', '1', '1', ''), ('581', '甸尾村委会', '530129009009', 'area', '1', '9', '506', '1', '1', ''), ('582', '山猱村', '530129009009001', 'area', '1', '1', '581', '1', '1', ''), ('583', '三石岩箐', '530129009009002', 'area', '1', '2', '581', '1', '1', ''), ('584', '小平地', '530129009009003', 'area', '1', '3', '581', '1', '1', ''), ('585', '丹桂村委会', '5301290090010', 'area', '1', '10', '506', '1', '1', ''), ('586', '丹桂村', '5301290090010001', 'area', '1', '1', '585', '1', '1', ''), ('587', '猴田', '5301290090010002', 'area', '1', '2', '585', '1', '1', ''), ('588', '柯渡村委会', '5301290090011', 'area', '1', '11', '506', '1', '1', ''), ('589', '木刻村委会', '5301290090012', 'area', '1', '12', '506', '1', '1', ''), ('590', '核桃箐', '5301290090012001', 'area', '1', '1', '589', '1', '1', ''), ('591', '长箐村委会', '5301290090013', 'area', '1', '13', '506', '1', '1', ''), ('592', '网兜哨', '5301290090013001', 'area', '1', '1', '591', '1', '1', ''), ('593', '七星镇', '5301290010', 'area', '1', '10', '29', '1', '1', ''), ('594', '七星村委会', '5301290010001', 'area', '1', '1', '593', '1', '1', ''), ('595', '勒塘1', '5301290010001001', 'area', '1', '1', '594', '1', '1', ''), ('596', '考武', '5301290010001002', 'area', '1', '2', '594', '1', '1', ''), ('597', '扯乃', '5301290010001003', 'area', '1', '3', '594', '1', '1', ''), ('598', '勒塘2', '5301290010001004', 'area', '1', '4', '594', '1', '1', ''), ('599', '桥上', '5301290010001005', 'area', '1', '5', '594', '1', '1', ''), ('600', '桥头', '5301290010001006', 'area', '1', '6', '594', '1', '1', ''), ('601', '三岔河', '5301290010001007', 'area', '1', '7', '594', '1', '1', ''), ('602', '石家湾', '5301290010001008', 'area', '1', '8', '594', '1', '1', ''), ('603', '雨得姑', '5301290010001009', 'area', '1', '9', '594', '1', '1', ''), ('604', '腊味村委会', '5301290010002', 'area', '1', '2', '593', '1', '1', ''), ('605', '白排', '5301290010002001', 'area', '1', '1', '604', '1', '1', ''), ('606', '坝者', '5301290010002002', 'area', '1', '2', '604', '1', '1', ''), ('607', '发易', '5301290010002003', 'area', '1', '3', '604', '1', '1', ''), ('608', '腊味', '5301290010002004', 'area', '1', '4', '604', '1', '1', ''), ('609', '鲁古', '5301290010002005', 'area', '1', '5', '604', '1', '1', ''), ('610', '下村', '5301290010002006', 'area', '1', '6', '604', '1', '1', ''), ('611', '则嘎', '5301290010002007', 'area', '1', '7', '604', '1', '1', ''), ('612', '宗儿', '5301290010002008', 'area', '1', '8', '604', '1', '1', ''), ('613', '江外村委会', '5301290010003', 'area', '1', '3', '593', '1', '1', ''), ('614', '江外', '5301290010003001', 'area', '1', '1', '613', '1', '1', ''), ('615', '可格', '5301290010003002', 'area', '1', '2', '613', '1', '1', ''), ('616', '龙潭冲', '5301290010003003', 'area', '1', '3', '613', '1', '1', ''), ('617', '新房子', '5301290010003004', 'area', '1', '4', '613', '1', '1', ''), ('618', '杨梅冲', '5301290010003005', 'area', '1', '5', '613', '1', '1', ''), ('619', '戈必村委会', '5301290010004', 'area', '1', '4', '593', '1', '1', ''), ('620', '大坝', '5301290010004001', 'area', '1', '1', '619', '1', '1', ''), ('621', '大新村', '5301290010004002', 'area', '1', '2', '619', '1', '1', ''), ('622', '戈必二', '5301290010004003', 'area', '1', '3', '619', '1', '1', ''), ('623', '戈必一', '5301290010004004', 'area', '1', '4', '619', '1', '1', ''), ('624', '海通', '5301290010004005', 'area', '1', '5', '619', '1', '1', ''), ('625', '黑麦地', '5301290010004006', 'area', '1', '6', '619', '1', '1', ''), ('626', '冷水田', '5301290010004007', 'area', '1', '7', '619', '1', '1', ''), ('627', '小庆', '5301290010004008', 'area', '1', '8', '619', '1', '1', ''), ('628', '小新村', '5301290010004009', 'area', '1', '9', '619', '1', '1', ''), ('629', '高田村委会', '5301290010005', 'area', '1', '5', '593', '1', '1', ''), ('630', '草子地', '5301290010005001', 'area', '1', '1', '629', '1', '1', ''), ('631', '大坝塘', '5301290010005002', 'area', '1', '2', '629', '1', '1', ''), ('632', '大碗冲', '5301290010005003', 'area', '1', '3', '629', '1', '1', ''), ('633', '鲁口哨', '5301290010005004', 'area', '1', '4', '629', '1', '1', ''), ('634', '蚂蝗塘', '5301290010005005', 'area', '1', '5', '629', '1', '1', ''), ('635', '毛家坝', '5301290010005006', 'area', '1', '6', '629', '1', '1', ''), ('636', '汤姑', '5301290010005007', 'area', '1', '7', '629', '1', '1', ''), ('637', '乌龙潭', '5301290010005008', 'area', '1', '8', '629', '1', '1', ''), ('638', '小碗冲', '5301290010005009', 'area', '1', '9', '629', '1', '1', ''), ('639', '江格村委会', '5301290010006', 'area', '1', '6', '593', '1', '1', ''), ('640', '戈宜', '5301290010006001', 'area', '1', '1', '639', '1', '1', ''), ('641', '江格', '5301290010006002', 'area', '1', '2', '639', '1', '1', ''), ('642', '上队', '5301290010006003', 'area', '1', '3', '639', '1', '1', ''), ('643', '下队', '5301290010006004', 'area', '1', '4', '639', '1', '1', ''), ('644', '向阳', '5301290010006005', 'area', '1', '5', '639', '1', '1', ''), ('645', '雨海', '5301290010006006', 'area', '1', '6', '639', '1', '1', ''), ('646', '必寨村委会', '5301290010007', 'area', '1', '7', '593', '1', '1', ''), ('647', '必寨', '5301290010007001', 'area', '1', '1', '646', '1', '1', ''), ('648', '大塘', '5301290010007002', 'area', '1', '2', '646', '1', '1', ''), ('649', '大我乡', '5301290010007003', 'area', '1', '3', '646', '1', '1', ''), ('650', '戈夸1组', '5301290010007004', 'area', '1', '4', '646', '1', '1', ''), ('651', '戈夸2组', '5301290010007005', 'area', '1', '5', '646', '1', '1', ''), ('652', '老湾地', '5301290010007006', 'area', '1', '6', '646', '1', '1', ''), ('653', '老长地1组', '5301290010007007', 'area', '1', '7', '646', '1', '1', ''), ('654', '水平街', '5301290010007008', 'area', '1', '8', '646', '1', '1', ''), ('655', '水平子', '5301290010007009', 'area', '1', '9', '646', '1', '1', ''), ('656', '窝子田', '53012900100070010', 'area', '1', '10', '646', '1', '1', ''), ('657', '小我乡', '53012900100070011', 'area', '1', '11', '646', '1', '1', ''), ('658', '总必1组', '53012900100070012', 'area', '1', '12', '646', '1', '1', ''), ('659', '总必2组', '53012900100070013', 'area', '1', '13', '646', '1', '1', ''), ('660', '塘子镇', '5301290011', 'area', '1', '11', '29', '1', '1', ''), ('661', '坝者村委会', '5301290011001', 'area', '1', '1', '660', '1', '1', ''), ('662', '坝者二社', '5301290011001001', 'area', '1', '1', '661', '1', '1', ''), ('663', '坝者四社', '5301290011001002', 'area', '1', '2', '661', '1', '1', ''), ('664', '坝者一社', '5301290011001003', 'area', '1', '3', '661', '1', '1', ''), ('665', '道院村委会', '5301290011002', 'area', '1', '2', '660', '1', '1', ''), ('666', '马石武', '5301290011002001', 'area', '1', '1', '665', '1', '1', ''), ('667', '小法古', '5301290011002002', 'area', '1', '2', '665', '1', '1', ''), ('668', '麦场村委会', '5301290011003', 'area', '1', '3', '660', '1', '1', ''), ('669', '下麦场10', '5301290011003001', 'area', '1', '1', '668', '1', '1', ''), ('670', '11组', '5301290011003001001', 'area', '1', '1', '669', '1', '1', ''), ('671', '小瓦匠12组', '5301290011003002', 'area', '1', '2', '668', '1', '1', ''), ('672', '中麦场8', '5301290011003003', 'area', '1', '3', '668', '1', '1', ''), ('673', '9组', '5301290011003003001', 'area', '1', '1', '672', '1', '1', ''), ('674', '三支龙村委会', '5301290011004', 'area', '1', '4', '660', '1', '1', ''), ('675', '关厂2组', '5301290011004001', 'area', '1', '1', '674', '1', '1', ''), ('676', '上村3组', '5301290011004002', 'area', '1', '2', '674', '1', '1', ''), ('677', '田房1组', '5301290011004003', 'area', '1', '3', '674', '1', '1', ''), ('678', '下村4社', '5301290011004004', 'area', '1', '4', '674', '1', '1', ''), ('679', '下村5社', '5301290011004005', 'area', '1', '5', '674', '1', '1', ''), ('680', '庄房6社', '5301290011004006', 'area', '1', '6', '674', '1', '1', ''), ('681', '塘子村委会', '5301290011005', 'area', '1', '5', '660', '1', '1', ''), ('682', '塘子二十二社', '5301290011005001', 'area', '1', '1', '681', '1', '1', ''), ('683', '塘子二十三社', '5301290011005002', 'area', '1', '2', '681', '1', '1', ''), ('684', '塘子二十社', '5301290011005003', 'area', '1', '3', '681', '1', '1', ''), ('685', '塘子二十一社', '5301290011005004', 'area', '1', '4', '681', '1', '1', ''), ('686', '塘子十八社', '5301290011005005', 'area', '1', '5', '681', '1', '1', ''), ('687', '塘子十九社', '5301290011005006', 'area', '1', '6', '681', '1', '1', ''), ('688', '塘子十七社', '5301290011005007', 'area', '1', '7', '681', '1', '1', ''), ('689', '塘子十四社', '5301290011005008', 'area', '1', '8', '681', '1', '1', ''), ('690', '塘子十一社', '5301290011005009', 'area', '1', '9', '681', '1', '1', ''), ('691', '塘子一社', '53012900110050010', 'area', '1', '10', '681', '1', '1', ''), ('692', '团结村委会', '5301290011006', 'area', '1', '6', '660', '1', '1', ''), ('693', '北山1', '5301290011006001', 'area', '1', '1', '692', '1', '1', ''), ('694', '2社', '5301290011006001001', 'area', '1', '1', '693', '1', '1', ''), ('695', '石板沟16', '5301290011006002', 'area', '1', '2', '692', '1', '1', ''), ('696', '17社', '5301290011006002001', 'area', '1', '1', '695', '1', '1', ''), ('697', '易隆村委会', '5301290011007', 'area', '1', '7', '660', '1', '1', ''), ('698', '大沙地12社', '5301290011007001', 'area', '1', '1', '697', '1', '1', ''), ('699', '蜂子岩15社', '5301290011007002', 'area', '1', '2', '697', '1', '1', ''), ('700', '老板桥16社', '5301290011007003', 'area', '1', '3', '697', '1', '1', ''), ('701', '老秧田7社', '5301290011007004', 'area', '1', '4', '697', '1', '1', ''), ('702', '梨树脑18社', '5301290011007005', 'area', '1', '5', '697', '1', '1', ''), ('703', '马田10社', '5301290011007006', 'area', '1', '6', '697', '1', '1', ''), ('704', '麦浪6社', '5301290011007007', 'area', '1', '7', '697', '1', '1', ''), ('705', '七里哨11社', '5301290011007008', 'area', '1', '8', '697', '1', '1', ''), ('706', '头道坝20社', '5301290011007009', 'area', '1', '9', '697', '1', '1', ''), ('707', '团团河5社', '53012900110070010', 'area', '1', '10', '697', '1', '1', ''), ('708', '小渔田17社', '53012900110070011', 'area', '1', '11', '697', '1', '1', ''), ('709', '新发村9社', '53012900110070012', 'area', '1', '12', '697', '1', '1', ''), ('710', '秧田箐13社', '53012900110070013', 'area', '1', '13', '697', '1', '1', ''), ('711', '易隆1社', '53012900110070014', 'area', '1', '14', '697', '1', '1', ''), ('712', '易隆2社', '53012900110070015', 'area', '1', '15', '697', '1', '1', ''), ('713', '易隆3社', '53012900110070016', 'area', '1', '16', '697', '1', '1', ''), ('714', '易隆4社', '53012900110070017', 'area', '1', '17', '697', '1', '1', ''), ('715', '云集村委会', '5301290011008', 'area', '1', '8', '660', '1', '1', ''), ('716', '陡坡弯11社', '5301290011008001', 'area', '1', '1', '715', '1', '1', ''), ('717', '卡泥村10社', '5301290011008002', 'area', '1', '2', '715', '1', '1', ''), ('718', '聂鼠龙3社', '5301290011008003', 'area', '1', '3', '715', '1', '1', ''), ('719', '秦家弯9社', '5301290011008004', 'area', '1', '4', '715', '1', '1', ''), ('720', '水渣凹1社', '5301290011008005', 'area', '1', '5', '715', '1', '1', ''), ('721', '王岗屯2社', '5301290011008006', 'area', '1', '6', '715', '1', '1', ''), ('722', '云丰村8社', '5301290011008007', 'area', '1', '7', '715', '1', '1', ''), ('723', '中桥村委会', '5301290011009', 'area', '1', '9', '660', '1', '1', ''), ('724', '初奈', '5301290011009001', 'area', '1', '1', '723', '1', '1', ''), ('725', '静乐庵', '5301290011009002', 'area', '1', '2', '723', '1', '1', ''), ('726', '木家山村', '5301290011009003', 'area', '1', '3', '723', '1', '1', ''), ('727', '钟灵村委会', '53012900110010', 'area', '1', '10', '660', '1', '1', ''), ('728', '车站村', '53012900110010001', 'area', '1', '1', '727', '1', '1', ''), ('729', '大凹1社', '53012900110010002', 'area', '1', '2', '727', '1', '1', ''), ('730', '黑水井', '53012900110010003', 'area', '1', '3', '727', '1', '1', ''), ('731', '梨树弯', '53012900110010004', 'area', '1', '4', '727', '1', '1', ''), ('732', '平坦子村', '53012900110010005', 'area', '1', '5', '727', '1', '1', ''), ('733', '普加屯', '53012900110010006', 'area', '1', '6', '727', '1', '1', ''), ('734', '山后村', '53012900110010007', 'area', '1', '7', '727', '1', '1', ''), ('735', '小海村', '53012900110010008', 'area', '1', '8', '727', '1', '1', ''), ('736', '阴地咀村', '53012900110010009', 'area', '1', '9', '727', '1', '1', ''), ('737', '张家屯1社', '530129001100100010', 'area', '1', '10', '727', '1', '1', ''), ('738', '新华村委会', '530129004002', 'area', '1', '2', '151', '1', '1', ''), ('739', '马六嘎', '530129004002001', 'area', '1', '1', '738', '1', '1', ''), ('740', '白章村委会', '530129004003', 'area', '1', '3', '151', '1', '1', ''), ('741', '茄卓', '530129004003001', 'area', '1', '1', '740', '1', '1', ''), ('742', '碑庄村委会', '530129004004', 'area', '1', '4', '151', '1', '1', ''), ('743', '碑庄', '530129004004001', 'area', '1', '1', '742', '1', '1', ''), ('744', '新平村委会', '530129004005', 'area', '1', '5', '151', '1', '1', ''), ('745', '放马哨', '530129004005001', 'area', '1', '1', '744', '1', '1', ''), ('746', '李家箐', '530129004005002', 'area', '1', '2', '744', '1', '1', ''), ('747', '汤郎', '530129004005003', 'area', '1', '3', '744', '1', '1', ''), ('748', '赵家村', '530129004005004', 'area', '1', '4', '744', '1', '1', ''), ('749', '海子村委会', '530129004006', 'area', '1', '6', '151', '1', '1', ''), ('750', '北海', '530129004006001', 'area', '1', '1', '749', '1', '1', ''), ('751', '海子', '530129004006002', 'area', '1', '2', '749', '1', '1', ''), ('752', '德著村委会', '530129004007', 'area', '1', '7', '151', '1', '1', ''), ('753', '德著', '530129004007001', 'area', '1', '1', '752', '1', '1', ''), ('754', '腊机卡', '530129004007002', 'area', '1', '2', '752', '1', '1', ''), ('755', '上甸尾', '530129004007003', 'area', '1', '3', '752', '1', '1', ''), ('756', '山都哨', '530129004007004', 'area', '1', '4', '752', '1', '1', ''), ('757', '竹园村委会', '530129004008', 'area', '1', '8', '151', '1', '1', ''), ('758', '大治北', '530129004008001', 'area', '1', '1', '757', '1', '1', ''), ('759', '东山村', '530129004008002', 'area', '1', '2', '757', '1', '1', ''), ('760', '姑鲁', '530129004008003', 'area', '1', '3', '757', '1', '1', ''), ('761', '洗勺', '530129004008004', 'area', '1', '4', '757', '1', '1', ''), ('762', '虎街村委会', '530129004009', 'area', '1', '9', '151', '1', '1', ''), ('763', '阿基泽', '530129004009001', 'area', '1', '1', '762', '1', '1', ''), ('764', '彩己', '530129004009002', 'area', '1', '2', '762', '1', '1', ''), ('765', '戈则务', '530129004009003', 'area', '1', '3', '762', '1', '1', ''), ('766', '骂秧村委会', '5301290040010', 'area', '1', '10', '151', '1', '1', ''), ('767', '安龙箐', '5301290040010001', 'area', '1', '1', '766', '1', '1', ''), ('768', '李资树', '5301290040010002', 'area', '1', '2', '766', '1', '1', ''), ('769', '骂秧', '5301290040010003', 'area', '1', '3', '766', '1', '1', ''), ('770', '计施宽村委会', '5301290040011', 'area', '1', '11', '151', '1', '1', ''), ('771', '箐水排', '5301290040011001', 'area', '1', '1', '770', '1', '1', ''), ('772', '散村子', '5301290040011002', 'area', '1', '2', '770', '1', '1', ''), ('773', '先锋镇', '5301290012', 'area', '1', '12', '29', '1', '1', ''), ('774', '富鲁村委会', '5301290012001', 'area', '1', '1', '773', '1', '1', ''), ('775', '大落白', '5301290012001001', 'area', '1', '1', '774', '1', '1', ''), ('776', '大转湾', '5301290012001002', 'area', '1', '2', '774', '1', '1', ''), ('777', '墩子', '5301290012001003', 'area', '1', '3', '774', '1', '1', ''), ('778', '富二社', '5301290012001004', 'area', '1', '4', '774', '1', '1', ''), ('779', '咪咪多', '5301290012001005', 'area', '1', '5', '774', '1', '1', ''), ('780', '石头地', '5301290012001006', 'area', '1', '6', '774', '1', '1', ''), ('781', '洗卡哩', '5301290012001007', 'area', '1', '7', '774', '1', '1', ''), ('782', '普鲁村委会', '5301290012002', 'area', '1', '2', '773', '1', '1', ''), ('783', '普鲁', '5301290012002001', 'area', '1', '1', '782', '1', '1', ''), ('784', '鲁土村委会', '5301290012003', 'area', '1', '3', '773', '1', '1', ''), ('785', '鲁土村', '5301290012003001', 'area', '1', '1', '784', '1', '1', ''), ('786', '马郎箐', '5301290012003002', 'area', '1', '2', '784', '1', '1', ''), ('787', '洒美姑', '5301290012003003', 'area', '1', '3', '784', '1', '1', ''), ('788', '姚家村', '5301290012003004', 'area', '1', '4', '784', '1', '1', ''), ('789', '窑上村委会', '5301290012004', 'area', '1', '4', '773', '1', '1', ''), ('790', '代家村', '5301290012004001', 'area', '1', '1', '789', '1', '1', ''), ('791', '恶歹', '5301290012004002', 'area', '1', '2', '789', '1', '1', ''), ('792', '郭家山', '5301290012004003', 'area', '1', '3', '789', '1', '1', ''), ('793', '鲁支本', '5301290012004004', 'area', '1', '4', '789', '1', '1', ''), ('794', '小村子', '5301290012004005', 'area', '1', '5', '789', '1', '1', ''), ('795', '宿家村', '5301290012004006', 'area', '1', '6', '789', '1', '1', ''), ('796', '窑上', '5301290012004007', 'area', '1', '7', '789', '1', '1', ''), ('797', '白子村村委会', '5301290012005', 'area', '1', '5', '773', '1', '1', ''), ('798', '白子村', '5301290012005001', 'area', '1', '1', '797', '1', '1', ''), ('799', '后沟箐', '5301290012005002', 'area', '1', '2', '797', '1', '1', ''), ('800', '贾白山', '5301290012005003', 'area', '1', '3', '797', '1', '1', ''), ('801', '团结村', '5301290012005004', 'area', '1', '4', '797', '1', '1', ''), ('802', '研究村', '5301290012005005', 'area', '1', '5', '797', '1', '1', ''), ('803', '干河东', '5301290012005006', 'area', '1', '6', '797', '1', '1', ''), ('804', '干西上', '5301290012005007', 'area', '1', '7', '797', '1', '1', ''), ('805', '鲁克山', '5301290012005008', 'area', '1', '8', '797', '1', '1', ''), ('806', '罗里勺', '5301290012005009', 'area', '1', '9', '797', '1', '1', ''), ('807', '木龙马村委会', '5301290012006', 'area', '1', '6', '773', '1', '1', ''), ('808', '大凹子', '5301290012006001', 'area', '1', '1', '807', '1', '1', ''), ('809', '大石洞', '5301290012006002', 'area', '1', '2', '807', '1', '1', ''), ('810', '大松棵', '5301290012006003', 'area', '1', '3', '807', '1', '1', ''), ('811', '罗锅克', '5301290012006004', 'area', '1', '4', '807', '1', '1', ''), ('812', '木龙马一组', '5301290012006005', 'area', '1', '5', '807', '1', '1', ''), ('813', '牛郎甸', '5301290012006006', 'area', '1', '6', '807', '1', '1', ''), ('814', '三哨坡', '5301290012006007', 'area', '1', '7', '807', '1', '1', ''), ('815', '上热呼洞', '5301290012006008', 'area', '1', '8', '807', '1', '1', ''), ('816', '响水箐', '5301290012006009', 'area', '1', '9', '807', '1', '1', ''), ('817', '羊街镇', '5301290013', 'area', '1', '13', '29', '1', '1', ''), ('818', '大刘所村委会', '5301290013001', 'area', '1', '1', '817', '1', '1', ''), ('819', '一片区', '5301290013001001', 'area', '1', '1', '818', '1', '1', ''), ('820', '二片区', '5301290013001002', 'area', '1', '2', '818', '1', '1', ''), ('821', '纳郎村委会', '5301290013002', 'area', '1', '2', '817', '1', '1', ''), ('822', '纳郎村一组', '5301290013002001', 'area', '1', '1', '821', '1', '1', ''), ('823', '清水沟村委会', '5301290013003', 'area', '1', '3', '817', '1', '1', ''), ('824', '丰乐村', '5301290013003001', 'area', '1', '1', '823', '1', '1', ''), ('825', '花箐哨村', '5301290013003002', 'area', '1', '2', '823', '1', '1', ''), ('826', '黄坡村', '5301290013003003', 'area', '1', '3', '823', '1', '1', ''), ('827', '清水沟村', '5301290013003004', 'area', '1', '4', '823', '1', '1', ''), ('828', '吴所村', '5301290013003005', 'area', '1', '5', '823', '1', '1', ''), ('829', '多合村委会', '5301290013004', 'area', '1', '4', '817', '1', '1', ''), ('830', '多合村一组', '5301290013004001', 'area', '1', '1', '829', '1', '1', ''), ('831', '多合村二组', '5301290013004002', 'area', '1', '2', '829', '1', '1', ''), ('832', '多合村三组', '5301290013004003', 'area', '1', '3', '829', '1', '1', ''), ('833', '多合村四组', '5301290013004004', 'area', '1', '4', '829', '1', '1', ''), ('834', '新街村委会', '5301290013005', 'area', '1', '5', '817', '1', '1', ''), ('835', '深沟村', '5301290013005001', 'area', '1', '1', '834', '1', '1', ''), ('836', '迟所村', '5301290013005002', 'area', '1', '2', '834', '1', '1', ''), ('837', '羊街村委会', '5301290013006', 'area', '1', '6', '817', '1', '1', ''), ('838', '长冲村委会', '5301290013007', 'area', '1', '7', '817', '1', '1', ''), ('839', '陡箐村', '5301290013007001', 'area', '1', '1', '838', '1', '1', ''), ('840', '古寨河村', '5301290013007002', 'area', '1', '2', '838', '1', '1', ''), ('841', '中村', '5301290013007003', 'area', '1', '3', '838', '1', '1', ''), ('842', '甸心村委会', '5301290013008', 'area', '1', '8', '817', '1', '1', ''), ('843', '二社', '5301290013008001', 'area', '1', '1', '842', '1', '1', ''), ('844', '一社', '5301290013008002', 'area', '1', '2', '842', '1', '1', ''), ('845', '烟站', '003', 'OrgStructType', '1', '2', '0', '0', '1', null), ('846', '部门', '002', 'OrgStructType', '1', '1', '0', '0', '1', null), ('847', '平台', '0101', 'DataDegree', '1', '0', '860', '0', '1', null), ('848', '本企业全部', '0102', 'DataDegree', '1', '1', '860', '0', '1', '{orgId:[UserPartnersOrgIds]}'), ('849', '本部门及以下', '0103', 'DataDegree', '1', '2', '860', '0', '1', 'orgId:[UserChildrenOrgIds]}'), ('851', '本部门', '0104', 'DataDegree', '1', '3', '860', '0', '1', '{orgId:[UserOrgId]}'), ('852', '只看自己', '0105', 'DataDegree', '1', '4', '860', '0', '1', '{createBy:[UserID]}'), ('854', '本区域及以下', '006', 'DataDegree', '1', '1', '861', '0', '1', '{areaCode:[UserChildrenArea]}'), ('855', '分类2', '002', 'ArticleLabel', '1', '13', '0', '1', '1', ''), ('856', '分类3', '003', 'ArticleLabel', '1', '0', '855', '0', '1', ''), ('858', 'test', '111', 'Classes', '1', '15', '0', '0', '0', ''), ('859', 'test2', '111', 'Classes', '1', '16', '0', '0', '0', ''), ('860', '组织结构纬度', '01', 'DataDegree', '1', '0', '0', '1', '1', ''), ('861', '区域纬度', '02', 'DataDegree', '1', '1', '0', '0', '1', ''), ('862', '全部区域', '0201', 'DataDegree', '1', '0', '861', '0', '1', ''), ('863', '企业', '001', 'OrgStructType', '1', '17', '0', '0', '1', ''), ('864', '公共分类', '001', 'ArticleLabelType', '1', '18', '0', '0', '1', ''), ('865', '私有分类', '002', 'ArticleLabelType', '1', '19', '0', '0', '1', '');
COMMIT;

-- ----------------------------
--  Table structure for `iframe_orgstruct`
-- ----------------------------
DROP TABLE IF EXISTS `iframe_orgstruct`;
CREATE TABLE `iframe_orgstruct` (
  `OS_ID` int(11) NOT NULL AUTO_INCREMENT,
  `OS_Name` varchar(50) DEFAULT NULL COMMENT '组织结构名称',
  `OS_Code` varchar(10) DEFAULT NULL COMMENT '企业编码',
  `OS_Type` char(10) DEFAULT NULL COMMENT '组织结构类型',
  `OS_IsParent` smallint(1) DEFAULT '0' COMMENT '是否是父级',
  `OS_ParentID` int(11) DEFAULT NULL COMMENT '父级ID',
  `OS_Admin_UserID` char(36) DEFAULT NULL COMMENT '负责人ID',
  `OS_Addr` varchar(50) DEFAULT NULL COMMENT '地址',
  `OS_Desc` varchar(100) DEFAULT NULL COMMENT '备注信息',
  `OS_PlatformRuleID` int(11) DEFAULT '0' COMMENT '功能套餐ID',
  `OS_PlatFormID` int(11) DEFAULT '0' COMMENT '平台ID',
  `OS_CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `OS_IsDel` smallint(1) DEFAULT '0',
  `OS_AreaCode` char(20) DEFAULT NULL COMMENT '所属区域',
  `OS_Sort` int(11) NOT NULL COMMENT '排序',
  `OS_IsShow` smallint(1) DEFAULT '1' COMMENT '是否可见',
  PRIMARY KEY (`OS_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `iframe_orgstruct`
-- ----------------------------
BEGIN;
INSERT INTO `iframe_orgstruct` VALUES ('-1', '平台', null, '001', '1', '0', null, null, null, '0', '0', null, '0', null, '0', '0'), ('1', '寻甸县烟草局', null, '001', '1', '0', null, 'qasd', null, '8', '1', '2018-06-22 09:02:09', '0', '530000', '1', '1'), ('2', '烟叶生产科', null, '002', '1', '1', null, null, null, '0', '0', '2018-06-22 09:03:05', '0', null, '0', '1'), ('3', '公司2', 'gs2', '001', '0', '2', null, null, null, '8', '1', '2018-06-22 13:13:06', '0', '530129', '0', '1'), ('4', '凤仪', null, '003', '0', '2', null, null, null, '0', '0', '2018-06-22 13:29:31', '0', '', '0', '1'), ('5', '功山', null, '003', '0', '2', null, null, null, '0', '0', '2018-06-22 13:29:46', '0', '', '0', '1'), ('6', '河口', null, '003', '0', '2', null, null, null, '0', '0', '2018-06-22 13:30:42', '0', '', '0', '1'), ('7', '鸡街', null, '003', '0', '2', null, null, null, '0', '0', '2018-06-22 13:34:37', '0', '', '0', '1'), ('8', '金所', null, '003', '0', '2', null, null, null, '0', '0', '2018-06-22 13:37:06', '0', '', '0', '1'), ('9', '金源', null, '003', '0', '2', null, null, null, '0', '0', '2018-06-22 13:37:51', '0', '', '0', '1'), ('10', '柯渡', null, '003', '0', '2', null, null, null, '0', '0', '2018-06-22 13:38:11', '0', '', '0', '1'), ('11', '七星', null, '003', '0', '2', null, null, null, '0', '0', '2018-06-22 13:38:56', '0', '', '0', '1'), ('12', '塘子', null, '003', '0', '2', null, null, null, '0', '0', '2018-06-22 13:41:36', '0', '', '0', '1'), ('13', '倘甸', null, '003', '0', '2', null, null, null, '0', '0', '2018-06-22 13:43:06', '0', '', '0', '1'), ('14', '先锋', null, '003', '0', '2', null, null, null, '0', '0', '2018-06-22 13:43:32', '0', '', '0', '1'), ('15', '羊街', null, '003', '0', '2', null, null, null, '0', '0', '2018-06-22 13:44:16', '0', '', '0', '1'), ('16', '公司3', 'gs3', '001', '0', '0', null, '3333', '111', '8', '1', '2018-09-19 10:48:22', '0', '530000', '2', '1'), ('17', '寻甸县烟草局', null, '001', '0', '0', null, null, null, '8', '0', '2018-09-21 13:49:38', '1', '530000', '0', '1'), ('23', '公司7', null, '001', '0', '0', null, null, null, '8', '1', '2018-09-24 22:18:22', '0', null, '3', '1'), ('24', 'test', null, '002', '0', '-1', null, null, null, '0', '0', '2018-09-26 11:51:41', '0', null, '0', '1');
COMMIT;

-- ----------------------------
--  Table structure for `iframe_partners`
-- ----------------------------
DROP TABLE IF EXISTS `iframe_partners`;
CREATE TABLE `iframe_partners` (
  `IP_ID` int(11) NOT NULL AUTO_INCREMENT,
  `IP_Name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '合作伙伴名称',
  `IP_NamePinyin` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '拼音',
  `IP_SystemName` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '系统名称',
  `IP_Sign` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '标识',
  `IP_Linker` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '联系人',
  `IP_LinkPhone` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '联系电话',
  `IP_Addr` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '地址',
  `IP_ParentID` int(11) DEFAULT '0' COMMENT '父级ID',
  `IP_Desc` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注信息',
  `IP_IsDel` smallint(6) DEFAULT '0' COMMENT '是否删除',
  `IP_PlatformRuleID` int(11) DEFAULT '0' COMMENT '功能套餐ID',
  `IP_PlatFormID` int(11) DEFAULT '0' COMMENT '平台ID',
  `IP_CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `IP_Bg` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '登录页面背景图',
  `IP_Logo` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `IP_Dict` text COLLATE utf8mb4_unicode_ci COMMENT '可见字典表设置',
  PRIMARY KEY (`IP_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `iframe_partners`
-- ----------------------------
BEGIN;
INSERT INTO `iframe_partners` VALUES ('8', '寻甸县烟草公司', 'xdxycgs', '寻甸县数字烟叶管理应用平台', 'xd', null, null, null, '0', null, '0', '8', '1', '2018-06-20 06:57:30', '/res/upload/img/20180620/1529477037-CB7BBB.png', '/res/upload/img/20180620/1529501736-8E6308.png', '{\"DataDegree\":[\"001\",\"002\"],\"dictLabel\":[\"ArticleLabel\",\"area\",\"OrgStructType\"],\"ArticleLabel\":[\"001\",\"002\",\"003\"],\"area\":[\"530000\",\"530129\",\"530129001\",\"530129001001\",\"530129001001001\",\"530129001001002\",\"530129001001003\",\"530129001001004\",\"530129001001005\",\"530129001001006\",\"530129001001007\",\"530129001001008\",\"530129001001009\",\"5301290010010010\",\"5301290010010011\",\"5301290010010012\",\"5301290010010013\",\"530129001002\",\"530129001002001\",\"530129001002002\",\"530129001002003\",\"530129001002004\",\"530129001002005\",\"530129001002006\",\"530129001002007\",\"530129001002008\",\"530129001003\",\"530129001003001\",\"530129001003002\",\"530129001003003\",\"530129001003004\",\"530129001003005\",\"530129001003006\",\"530129001003007\",\"530129001004\",\"530129001004001\",\"530129001004002\",\"530129001004003\",\"530129001004004\",\"530129001004005\",\"530129001005\",\"530129001005001\",\"530129001005002\",\"530129001005003\",\"530129001005004\",\"530129001005005\",\"530129001005006\",\"530129001005007\",\"530129001005008\",\"530129001006\",\"530129001006001\",\"530129001006002\",\"530129001006003\",\"530129001006004\",\"530129001006005\",\"530129001006006\",\"530129001006007\",\"530129001007\",\"530129001007001\",\"530129001007002\",\"530129001007003\",\"530129002\",\"530129002001\",\"530129002001001\",\"530129002001002\",\"530129002002\",\"530129002002001\",\"530129002002002\",\"530129002003\",\"530129002003001\",\"530129002003002\",\"530129002003003\",\"530129002003004\",\"530129002003005\",\"530129002004\",\"530129002004001\",\"530129002004002\",\"530129002004003\",\"530129002004004\",\"530129002005\",\"530129002005001\",\"530129002006\",\"530129002006001\",\"530129002007\",\"530129002007001\",\"530129002007002\",\"530129002008\",\"530129002008001\",\"530129002009\",\"530129002009001\",\"5301290020010\",\"5301290020010001\",\"5301290020010002\",\"5301290020010003\",\"5301290020011\",\"5301290020011001\",\"5301290020011002\",\"5301290020011003\",\"5301290020011004\",\"5301290020011005\",\"530129003\",\"530129003001\",\"530129003001001\",\"530129003001002\",\"530129003001003\",\"530129003001004\",\"530129003001005\",\"530129003002\",\"530129003002001\",\"530129003002002\",\"530129003002003\",\"530129003002004\",\"530129003002005\",\"530129003002006\",\"530129003002007\",\"530129003003\",\"530129003003001\",\"530129003004\",\"530129003004001\",\"530129003004002\",\"530129003004003\",\"530129003004004\",\"530129003005\",\"530129003005001\",\"530129003005002\",\"530129003005003\",\"530129003005004\",\"530129003006\",\"530129003006001\",\"530129003006002\",\"530129003006003\",\"530129003006004\",\"530129003006005\",\"530129003006006\",\"530129003006007\",\"530129003006008\",\"530129003007\",\"530129003008\",\"530129003008001\",\"530129003008002\",\"530129003008003\",\"530129003008004\",\"530129003008005\",\"530129003009\",\"530129003009001\",\"530129003009002\",\"530129003009003\",\"530129003009004\",\"5301290030010\",\"5301290030010001\",\"5301290030011\",\"530129004\",\"530129004001\",\"530129004001001\",\"530129004001002\",\"530129004001003\",\"530129004001004\",\"530129004001005\",\"530129004001006\",\"530129004001007\",\"530129004002\",\"530129004002001\",\"530129004003\",\"530129004003001\",\"530129004004\",\"530129004004001\",\"530129004005\",\"530129004005001\",\"530129004005002\",\"530129004005003\",\"530129004005004\",\"530129004006\",\"530129004006001\",\"530129004006002\",\"530129004007\",\"530129004007001\",\"530129004007002\",\"530129004007003\",\"530129004007004\",\"530129004008\",\"530129004008001\",\"530129004008002\",\"530129004008003\",\"530129004008004\",\"530129004009\",\"530129004009001\",\"530129004009002\",\"530129004009003\",\"5301290040010\",\"5301290040010001\",\"5301290040010002\",\"5301290040010003\",\"5301290040011\",\"5301290040011001\",\"5301290040011002\",\"530129005\",\"530129005001\",\"530129005001001\",\"530129005001002\",\"530129005001003\",\"530129005001004\",\"530129005001005\",\"530129005001006\",\"530129005001007\",\"530129005001008\",\"530129005002\",\"530129005002001\",\"530129005002002\",\"530129005002003\",\"530129005002004\",\"530129005002005\",\"530129005002006\",\"530129005002007\",\"530129005002008\",\"530129005002009\",\"5301290050020010\",\"5301290050020011\",\"530129005003\",\"530129005003001\",\"530129005003002\",\"530129005003003\",\"530129005003004\",\"530129005003005\",\"530129005003006\",\"530129005003007\",\"530129005003008\",\"530129005003009\",\"5301290050030010\",\"5301290050030011\",\"5301290050030012\",\"5301290050030013\",\"5301290050030014\",\"5301290050030015\",\"530129005004\",\"530129005004001\",\"530129005004002\",\"530129005004003\",\"530129005004004\",\"530129005004005\",\"530129005004006\",\"530129005004007\",\"530129005004008\",\"530129005004009\",\"5301290050040010\",\"5301290050040011\",\"5301290050040012\",\"530129005005\",\"530129005005001\",\"530129005005002\",\"530129005005003\",\"530129005005004\",\"530129005005005\",\"530129005005006\",\"530129005005007\",\"530129005005008\",\"530129005005009\",\"5301290050050010\",\"530129005006\",\"530129005006001\",\"530129005006002\",\"530129005006003\",\"530129005006004\",\"530129005006005\",\"530129005006006\",\"530129005006007\",\"530129005006008\",\"530129005006009\",\"5301290050060010\",\"5301290050060011\",\"5301290050060012\",\"5301290050060013\",\"530129005007\",\"530129005007001\",\"530129005007002\",\"530129005007003\",\"530129005007004\",\"530129005007005\",\"530129005007006\",\"530129005007007\",\"530129005007008\",\"530129005007009\",\"5301290050070010\",\"530129005008\",\"530129005008001\",\"530129005008002\",\"530129005008003\",\"530129005008004\",\"530129005008005\",\"530129005008006\",\"530129005008007\",\"530129005008008\",\"530129005008009\",\"530129005009\",\"530129005009001\",\"530129005009002\",\"530129005009003\",\"530129005009004\",\"530129005009005\",\"530129005009006\",\"5301290050010\",\"5301290050010001\",\"5301290050010002\",\"5301290050010003\",\"5301290050010004\",\"5301290050010005\",\"5301290050010006\",\"5301290050010007\",\"5301290050010008\",\"5301290050010009\",\"5301290050011\",\"5301290050011001\",\"5301290050011002\",\"5301290050011003\",\"5301290050011004\",\"5301290050011005\",\"5301290050011006\",\"5301290050012\",\"5301290050012001\",\"5301290050012002\",\"5301290050012003\",\"5301290050012004\",\"5301290050012005\",\"5301290050012006\",\"5301290050012007\",\"5301290050012008\",\"5301290050012009\",\"53012900500120010\",\"53012900500120011\",\"53012900500120012\",\"53012900500120013\",\"53012900500120014\",\"53012900500120015\",\"5301290050013\",\"5301290050013001\",\"5301290050013002\",\"5301290050013003\",\"5301290050013004\",\"5301290050013005\",\"5301290050013006\",\"5301290050013007\",\"5301290050013008\",\"5301290050013009\",\"5301290050014\",\"5301290050014001\",\"5301290050014002\",\"5301290050014003\",\"5301290050014004\",\"5301290050014005\",\"5301290050014006\",\"5301290050014007\",\"5301290050015\",\"5301290050015001\",\"5301290050015002\",\"5301290050015003\",\"5301290050015004\",\"5301290050015005\",\"5301290050015006\",\"5301290050015007\",\"5301290050015008\",\"5301290050015009\",\"53012900500150010\",\"5301290050016\",\"5301290050016001\",\"5301290050016002\",\"5301290050016003\",\"5301290050016004\",\"5301290050016005\",\"5301290050016006\",\"5301290050016007\",\"5301290050016008\",\"5301290050016009\",\"53012900500160010\",\"530129006\",\"530129006001\",\"530129006001001\",\"530129006001002\",\"530129006001003\",\"530129006001004\",\"530129006002\",\"530129006002001\",\"530129006002002\",\"530129006002003\",\"530129006002004\",\"530129006002005\",\"530129006002006\",\"530129006002007\",\"530129006002008\",\"530129006002009\",\"530129006003\",\"530129006003001\",\"530129006003002\",\"530129006003003\",\"530129006003004\",\"530129006003005\",\"530129006003006\",\"530129006004\",\"530129006004001\",\"530129006004002\",\"530129006004003\",\"530129006004004\",\"530129006004005\",\"530129006004006\",\"530129006005\",\"530129006005001\",\"530129006005002\",\"530129006005003\",\"530129006006\",\"530129006006001\",\"530129006006002\",\"530129006006003\",\"530129006006004\",\"530129006006005\",\"530129006006006\",\"530129006006007\",\"530129006006008\",\"530129006006009\",\"5301290060060010\",\"5301290060060011\",\"530129006007\",\"530129006007001\",\"530129006007002\",\"530129006007003\",\"530129006007004\",\"530129006007005\",\"530129006007006\",\"530129006007007\",\"530129006007008\",\"530129006008\",\"530129006008001\",\"530129006008002\",\"530129006008003\",\"530129006008004\",\"530129006008005\",\"530129006008006\",\"530129006008007\",\"530129006008008\",\"530129006008009\",\"5301290060080010\",\"5301290060080011\",\"5301290060080012\",\"5301290060080013\",\"530129006009\",\"530129006009001\",\"530129006009002\",\"530129006009003\",\"5301290060010\",\"5301290060010001\",\"5301290060010002\",\"5301290060010003\",\"5301290060010004\",\"5301290060010005\",\"5301290060011\",\"5301290060011001\",\"5301290060011002\",\"5301290060011003\",\"5301290060011004\",\"5301290060011005\",\"5301290060011006\",\"5301290060011007\",\"5301290060011008\",\"5301290060011009\",\"53012900600110010\",\"530129007\",\"530129007001\",\"530129007001001\",\"530129007002\",\"530129007002001\",\"530129007002002\",\"530129007003\",\"530129007003001\",\"530129007003002\",\"530129007003003\",\"530129007003004\",\"530129007004\",\"530129007004001\",\"530129007004002\",\"530129007004003\",\"530129007005\",\"530129007005001\",\"530129007005002\",\"530129007005003\",\"530129007006\",\"530129007006001\",\"530129007006002\",\"530129008\",\"530129008001\",\"530129008001001\",\"530129008001002\",\"530129008001003\",\"530129008001004\",\"530129008001005\",\"530129008002\",\"530129008002001\",\"530129008002002\",\"530129008002003\",\"530129008002004\",\"530129008003\",\"530129008003001\",\"530129008003002\",\"530129008003003\",\"530129008004\",\"530129008004001\",\"530129008004002\",\"530129008005\",\"530129008005001\",\"530129009\",\"530129009001\",\"530129009001001\",\"530129009001002\",\"530129009001003\",\"530129009001004\",\"530129009001005\",\"530129009001006\",\"530129009001007\",\"530129009001008\",\"530129009001009\",\"5301290090010010\",\"5301290090010011\",\"5301290090010012\",\"5301290090010013\",\"530129009002\",\"530129009002001\",\"530129009002002\",\"530129009002003\",\"530129009002004\",\"530129009002005\",\"530129009002006\",\"530129009002007\",\"530129009002008\",\"530129009002009\",\"5301290090020010\",\"5301290090020011\",\"5301290090020012\",\"5301290090020013\",\"5301290090020014\",\"530129009003\",\"530129009003001\",\"530129009003002\",\"530129009003003\",\"530129009003004\",\"530129009003005\",\"530129009003006\",\"530129009004\",\"530129009004001\",\"530129009004002\",\"530129009004003\",\"530129009004004\",\"530129009004005\",\"530129009004006\",\"530129009004007\",\"530129009005\",\"530129009005001\",\"530129009005002\",\"530129009005003\",\"530129009006\",\"530129009006001\",\"530129009006002\",\"530129009006003\",\"530129009006004\",\"530129009006005\",\"530129009006006\",\"530129009006007\",\"530129009006008\",\"530129009006009\",\"5301290090060010\",\"5301290090060011\",\"5301290090060012\",\"5301290090060013\",\"5301290090060014\",\"530129009007\",\"530129009007001\",\"530129009007002\",\"530129009007003\",\"530129009007004\",\"530129009007005\",\"530129009008\",\"530129009008001\",\"530129009008002\",\"530129009008003\",\"530129009008004\",\"530129009009\",\"530129009009001\",\"530129009009002\",\"530129009009003\",\"5301290090010\",\"5301290090010001\",\"5301290090010002\",\"5301290090011\",\"5301290090012\",\"5301290090012001\",\"5301290090013\",\"5301290090013001\",\"5301290010\",\"5301290010001\",\"5301290010001001\",\"5301290010001002\",\"5301290010001003\",\"5301290010001004\",\"5301290010001005\",\"5301290010001006\",\"5301290010001007\",\"5301290010001008\",\"5301290010001009\",\"5301290010002\",\"5301290010002001\",\"5301290010002002\",\"5301290010002003\",\"5301290010002004\",\"5301290010002005\",\"5301290010002006\",\"5301290010002007\",\"5301290010002008\",\"5301290010003\",\"5301290010003001\",\"5301290010003002\",\"5301290010003003\",\"5301290010003004\",\"5301290010003005\",\"5301290010004\",\"5301290010004001\",\"5301290010004002\",\"5301290010004003\",\"5301290010004004\",\"5301290010004005\",\"5301290010004006\",\"5301290010004007\",\"5301290010004008\",\"5301290010004009\",\"5301290010005\",\"5301290010005001\",\"5301290010005002\",\"5301290010005003\",\"5301290010005004\",\"5301290010005005\",\"5301290010005006\",\"5301290010005007\",\"5301290010005008\",\"5301290010005009\",\"5301290010006\",\"5301290010006001\",\"5301290010006002\",\"5301290010006003\",\"5301290010006004\",\"5301290010006005\",\"5301290010006006\",\"5301290010007\",\"5301290010007001\",\"5301290010007002\",\"5301290010007003\",\"5301290010007004\",\"5301290010007005\",\"5301290010007006\",\"5301290010007007\",\"5301290010007008\",\"5301290010007009\",\"53012900100070010\",\"53012900100070011\",\"53012900100070012\",\"53012900100070013\",\"5301290011\",\"5301290011001\",\"5301290011001001\",\"5301290011001002\",\"5301290011001003\",\"5301290011002\",\"5301290011002001\",\"5301290011002002\",\"5301290011003\",\"5301290011003001\",\"5301290011003001001\",\"5301290011003002\",\"5301290011003003\",\"5301290011003003001\",\"5301290011004\",\"5301290011004001\",\"5301290011004002\",\"5301290011004003\",\"5301290011004004\",\"5301290011004005\",\"5301290011004006\",\"5301290011005\",\"5301290011005001\",\"5301290011005002\",\"5301290011005003\",\"5301290011005004\",\"5301290011005005\",\"5301290011005006\",\"5301290011005007\",\"5301290011005008\",\"5301290011005009\",\"53012900110050010\",\"5301290011006\",\"5301290011006001\",\"5301290011006001001\",\"5301290011006002\",\"5301290011006002001\",\"5301290011007\",\"5301290011007001\",\"5301290011007002\",\"5301290011007003\",\"5301290011007004\",\"5301290011007005\",\"5301290011007006\",\"5301290011007007\",\"5301290011007008\",\"5301290011007009\",\"53012900110070010\",\"53012900110070011\",\"53012900110070012\",\"53012900110070013\",\"53012900110070014\",\"53012900110070015\",\"53012900110070016\",\"53012900110070017\",\"5301290011008\",\"5301290011008001\",\"5301290011008002\",\"5301290011008003\",\"5301290011008004\",\"5301290011008005\",\"5301290011008006\",\"5301290011008007\",\"5301290011009\",\"5301290011009001\",\"5301290011009002\",\"5301290011009003\",\"53012900110010\",\"53012900110010001\",\"53012900110010002\",\"53012900110010003\",\"53012900110010004\",\"53012900110010005\",\"53012900110010006\",\"53012900110010007\",\"53012900110010008\",\"53012900110010009\",\"530129001100100010\",\"5301290012\",\"5301290012001\",\"5301290012001001\",\"5301290012001002\",\"5301290012001003\",\"5301290012001004\",\"5301290012001005\",\"5301290012001006\",\"5301290012001007\",\"5301290012002\",\"5301290012002001\",\"5301290012003\",\"5301290012003001\",\"5301290012003002\",\"5301290012003003\",\"5301290012003004\",\"5301290012004\",\"5301290012004001\",\"5301290012004002\",\"5301290012004003\",\"5301290012004004\",\"5301290012004005\",\"5301290012004006\",\"5301290012004007\",\"5301290012005\",\"5301290012005001\",\"5301290012005002\",\"5301290012005003\",\"5301290012005004\",\"5301290012005005\",\"5301290012005006\",\"5301290012005007\",\"5301290012005008\",\"5301290012005009\",\"5301290012006\",\"5301290012006001\",\"5301290012006002\",\"5301290012006003\",\"5301290012006004\",\"5301290012006005\",\"5301290012006006\",\"5301290012006007\",\"5301290012006008\",\"5301290012006009\",\"5301290013\",\"5301290013001\",\"5301290013001001\",\"5301290013001002\",\"5301290013002\",\"5301290013002001\",\"5301290013003\",\"5301290013003001\",\"5301290013003002\",\"5301290013003003\",\"5301290013003004\",\"5301290013003005\",\"5301290013004\",\"5301290013004001\",\"5301290013004002\",\"5301290013004003\",\"5301290013004004\",\"5301290013005\",\"5301290013005001\",\"5301290013005002\",\"5301290013006\",\"5301290013007\",\"5301290013007001\",\"5301290013007002\",\"5301290013007003\",\"5301290013008\",\"5301290013008001\",\"5301290013008002\"],\"OrgStructType\":[\"001\",\"002\"]}'), ('9', 'kmss', 'k', 'xx', 'xx', 'as', '11', '111', '0', null, '0', '8', '1', '2018-09-04 20:41:03', '/res/upload/img/20180904/1536064853-482C5A.png', '/res/upload/img/20180904/1536064847-1D2607.png', '{\"dictLabel\":[\"DataDegree\"],\"DataDegree\":[\"001\",\"002\",\"003\",\"004\",\"005\",\"006\",\"999\"]}');
COMMIT;

-- ----------------------------
--  Table structure for `iframe_partners_dict`
-- ----------------------------
DROP TABLE IF EXISTS `iframe_partners_dict`;
CREATE TABLE `iframe_partners_dict` (
  `zd_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '字典表',
  `zd_Name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `zd_value` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '值',
  `zd_label` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '类型',
  `zd_sort` int(11) NOT NULL DEFAULT '0',
  `zd_ParentID` int(11) NOT NULL DEFAULT '0',
  `zd_IsParent` int(1) NOT NULL DEFAULT '0',
  `zd_IsShow` int(1) NOT NULL DEFAULT '1',
  `zd_Attr` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '属性',
  `zd_partners_id` int(11) DEFAULT '0' COMMENT '合作伙伴ID',
  PRIMARY KEY (`zd_ID`),
  KEY `NewIndex1` (`zd_label`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `iframe_partners_dict`
-- ----------------------------
BEGIN;
INSERT INTO `iframe_partners_dict` VALUES ('31', '副经理', '002', 'UserType', '1', '0', '0', '1', null, '1'), ('32', '站长', '003', 'UserType', '2', '0', '0', '1', null, '1'), ('33', '局长', '001', 'UserType', '0', '0', '0', '1', null, '1'), ('35', '技术员', '004', 'UserType', '3', '0', '0', '1', null, '1'), ('36', '生产辅导员', '005', 'UserType', '4', '0', '0', '1', null, '1'), ('37', '烘烤辅导员', '006', 'UserType', '5', '0', '0', '1', null, '1'), ('38', '用户预检员', '007', 'UserType', '6', '0', '0', '1', null, '1'), ('39', '专业化分拣员', '008', 'UserType', '7', '0', '0', '1', null, '1'), ('41', '员工', '01', 'UserType', '8', '0', '0', '1', '', '-1'), ('42', '经理', '02', 'UserType', '9', '0', '0', '1', '', '-1'), ('43', '爱爱爱', '11', 'UserType', '10', '0', '0', '1', '', '-1'), ('44', '爱爱爱', '11', 'UserType', '11', '0', '0', '1', '', '-1'), ('45', 'wa', 'a', 'UserType', '12', '0', '0', '0', '', '-1');
COMMIT;

-- ----------------------------
--  Table structure for `iframe_platform`
-- ----------------------------
DROP TABLE IF EXISTS `iframe_platform`;
CREATE TABLE `iframe_platform` (
  `IP_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '平台ID',
  `IP_Sign` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标记字符串',
  `IP_Name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '平台名称',
  `IP_IsDel` smallint(6) DEFAULT NULL COMMENT '是否被删除',
  `IP_CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `IP_Info` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '平台描述',
  PRIMARY KEY (`IP_ID`),
  UNIQUE KEY `PlatformSign` (`IP_Sign`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `iframe_platform`
-- ----------------------------
BEGIN;
INSERT INTO `iframe_platform` VALUES ('1', 'tobacco', '智慧烟草系统', '0', '2015-12-07 16:25:38', '');
COMMIT;

-- ----------------------------
--  Table structure for `iframe_platform_rule`
-- ----------------------------
DROP TABLE IF EXISTS `iframe_platform_rule`;
CREATE TABLE `iframe_platform_rule` (
  `RuleID` int(11) NOT NULL AUTO_INCREMENT,
  `RuleName` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RuleInfo` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `RuleDict` text COLLATE utf8mb4_unicode_ci COMMENT '套餐可用的字典表选项',
  `RuleAble` text COLLATE utf8mb4_unicode_ci,
  `RulePlatformID` int(11) DEFAULT '0',
  `CreateTime` datetime DEFAULT NULL,
  `IsDel` smallint(6) DEFAULT '0',
  PRIMARY KEY (`RuleID`),
  KEY `RulePlatformID` (`RulePlatformID`),
  CONSTRAINT `iframe_platform_rule_ibfk_1` FOREIGN KEY (`RulePlatformID`) REFERENCES `iframe_platform` (`IP_ID`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `iframe_platform_rule`
-- ----------------------------
BEGIN;
INSERT INTO `iframe_platform_rule` VALUES ('8', '企业版', '', '{\"DataDegree\":[\"0103\",\"0104\",\"0105\",\"02\",\"0201\",\"006\"],\"dictLabel\":[\"ArticleLabel\",\"OrgStructType\"],\"ArticleLabel\":[\"001\",\"002\",\"003\"],\"OrgStructType\":[\"002\",\"003\",\"001\"]}', '[{\"M\":4,\"A\":\"\",\"D\":[]},{\"M\":7,\"A\":\"\",\"D\":[]},{\"M\":5,\"A\":\"\",\"D\":[]},{\"M\":6,\"A\":\"\",\"D\":[]},{\"M\":41,\"A\":\"\",\"D\":[]},{\"M\":264,\"A\":\"\",\"D\":[{\"label\":\"全部可见\",\"value\":\"{All:1}\"},{\"label\":\"部门及以下\",\"value\":\"{All:2}\"}]},{\"M\":265,\"A\":\"\",\"D\":[]},{\"M\":318,\"A\":\"\",\"D\":[]},{\"M\":355,\"A\":\"\",\"D\":[]},{\"M\":319,\"A\":\"\",\"D\":[]},{\"M\":320,\"A\":\"\",\"D\":[]},{\"M\":341,\"A\":\"\",\"D\":[]},{\"M\":342,\"A\":\"\",\"D\":[]},{\"M\":343,\"A\":\"\",\"D\":[]},{\"M\":344,\"A\":\"\",\"D\":[]},{\"M\":345,\"A\":\"\",\"D\":[]},{\"M\":349,\"A\":\"\",\"D\":[]},{\"M\":350,\"A\":\"\",\"D\":[]},{\"M\":353,\"A\":\"\",\"D\":[]},{\"M\":354,\"A\":\"\",\"D\":[]},{\"M\":366,\"A\":\"\",\"D\":[]}]', '1', '2018-06-14 16:49:43', '0'), ('9', '测试1', '122', null, '[{\"M\":318,\"A\":\"\",\"D\":[]},{\"M\":355,\"A\":\"\",\"D\":[]},{\"M\":319,\"A\":\"\",\"D\":[]},{\"M\":320,\"A\":\"\",\"D\":[]},{\"M\":341,\"A\":\"\",\"D\":[]},{\"M\":342,\"A\":\"\",\"D\":[]},{\"M\":343,\"A\":\"\",\"D\":[]},{\"M\":344,\"A\":\"\",\"D\":[]},{\"M\":345,\"A\":\"\",\"D\":[]},{\"M\":349,\"A\":\"\",\"D\":[]},{\"M\":350,\"A\":\"\",\"D\":[]}]', '1', '2018-09-02 21:19:08', '1');
COMMIT;

-- ----------------------------
--  Table structure for `iframe_rule`
-- ----------------------------
DROP TABLE IF EXISTS `iframe_rule`;
CREATE TABLE `iframe_rule` (
  `RuleID` int(11) NOT NULL AUTO_INCREMENT,
  `RuleName` varchar(50) DEFAULT NULL,
  `RuleInfo` varchar(50) DEFAULT NULL,
  `RuleAble` text,
  `RuleOrgID` int(11) DEFAULT '0' COMMENT '所属组织机构ID(包括公司)',
  `RulePartnersID` int(11) DEFAULT '0' COMMENT '所属合作伙伴ID',
  `RuleDataDegreeCode` varchar(50) DEFAULT NULL COMMENT '数据可见程度',
  `RuleCustomDataDegree` varchar(255) DEFAULT '' COMMENT '自定义数据可见程度',
  PRIMARY KEY (`RuleID`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `iframe_rule`
-- ----------------------------
BEGIN;
INSERT INTO `iframe_rule` VALUES ('58', '技术员', null, '[{\"M\":264,\"A\":\"\",\"D\":{\"label\":\"部门及以下\",\"value\":\"{All:2}\"}},{\"M\":4,\"A\":\"\",\"D\":{}},{\"M\":7,\"A\":\"\",\"D\":{}}]', '1', '1', '003', null), ('59', '辅导员', null, '[{\"M\":264,\"A\":\"\",\"D\":{\"label\":\"部门及以下\",\"value\":\"{All:2}\"}},{\"M\":4,\"A\":\"\",\"D\":{}},{\"M\":7,\"A\":\"\",\"D\":{}}]', '1', '1', '003', null), ('61', '管理员', '回复', '[{\"M\":264,\"A\":\"\",\"D\":{\"label\":\"部门及以下\",\"value\":\"{All:2}\"}},{\"M\":4,\"A\":\"\",\"D\":{}},{\"M\":7,\"A\":\"\",\"D\":{}},{\"M\":318,\"A\":\"\",\"D\":{}},{\"M\":355,\"A\":\"\",\"D\":{}},{\"M\":319,\"A\":\"禁止删除\",\"D\":{}},{\"M\":320,\"A\":\"\",\"D\":{}},{\"M\":341,\"A\":\"\",\"D\":{}},{\"M\":342,\"A\":\"\",\"D\":{}},{\"M\":343,\"A\":\"\",\"D\":{}},{\"M\":344,\"A\":\"禁止删除\",\"D\":{}},{\"M\":345,\"A\":\"\",\"D\":{}}]', '1', '1', '002', null), ('63', '普通管理员', null, '[{\"M\":4,\"A\":\"\",\"D\":{}},{\"M\":7,\"A\":\"\",\"D\":{}},{\"M\":5,\"A\":\"\",\"D\":{}},{\"M\":6,\"A\":\"\",\"D\":{}},{\"M\":41,\"A\":\"\",\"D\":{}},{\"M\":264,\"A\":\"\",\"D\":{}},{\"M\":265,\"A\":\"\",\"D\":{}},{\"M\":266,\"A\":\"\",\"D\":{}},{\"M\":281,\"A\":\"\",\"D\":{}},{\"M\":283,\"A\":\"\",\"D\":{}},{\"M\":284,\"A\":\"\",\"D\":{}},{\"M\":285,\"A\":\"\",\"D\":{}},{\"M\":310,\"A\":\"\",\"D\":{}},{\"M\":311,\"A\":\"\",\"D\":{}},{\"M\":313,\"A\":\"\",\"D\":{}},{\"M\":317,\"A\":\"\",\"D\":{}},{\"M\":318,\"A\":\"\",\"D\":{}},{\"M\":355,\"A\":\"\",\"D\":{}},{\"M\":319,\"A\":\"\",\"D\":{}},{\"M\":320,\"A\":\"\",\"D\":{}},{\"M\":341,\"A\":\"\",\"D\":{}},{\"M\":342,\"A\":\"\",\"D\":{}},{\"M\":343,\"A\":\"\",\"D\":{}},{\"M\":344,\"A\":\"\",\"D\":{}},{\"M\":345,\"A\":\"\",\"D\":{}},{\"M\":349,\"A\":\"\",\"D\":{}},{\"M\":350,\"A\":\"\",\"D\":{}},{\"M\":366,\"A\":\"\",\"D\":{}}]', '-1', '-1', '0102,0201', '');
COMMIT;

-- ----------------------------
--  Table structure for `iframe_system_module`
-- ----------------------------
DROP TABLE IF EXISTS `iframe_system_module`;
CREATE TABLE `iframe_system_module` (
  `ModuleID` bigint(20) NOT NULL,
  `Name` varchar(50) DEFAULT NULL,
  `URL` varchar(200) DEFAULT NULL,
  `UrlGoModuleID` bigint(20) DEFAULT NULL,
  `ParentID` bigint(20) DEFAULT NULL,
  `Sort` int(11) NOT NULL,
  `IsParent` int(11) NOT NULL,
  `Icon` varchar(50) DEFAULT NULL,
  `Able` varchar(200) DEFAULT NULL,
  `IsShowInMenu` int(11) NOT NULL,
  `Remark` varchar(100) DEFAULT NULL,
  `IsShowLeftMenu` int(11) DEFAULT '1' COMMENT '激活后，是否显示左边菜单栏',
  `DataOptions` text COMMENT '数据可见程度配置',
  PRIMARY KEY (`ModuleID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `iframe_system_module`
-- ----------------------------
BEGIN;
INSERT INTO `iframe_system_module` VALUES ('1', '系统模块设置', '/manage/System/SystemModule', '0', '7', '7', '0', 'cube', '', '2', '配置系统中可用的功能模块', '1', null), ('2', '参数设置', '', '-1', '7', '1', '1', 'bonfire', '', '2', '', '1', null), ('4', '系统用户', '', '-1', '7', '4', '1', 'ios-people', '', '2', '', '1', null), ('5', '系统角色', '', '41', '7', '5', '1', 'ios-barcode-outline', '', '2', '', '1', null), ('6', '角色设置', '/Manage/System/Rule/Edit', '0', '5', '1', '0', 'icon-note', '', '3', '', '1', null), ('7', '系统管理', '', '-1', '0', '4', '1', 'wrench', '', '1', '', '1', null), ('41', '角色管理', '/manage/System/Rule/Manage', '0', '5', '0', '0', 'icon-list', '禁止编辑 禁止删除', '3', '', '1', null), ('264', '查询', '/manage/system/admin-user/manage', '0', '4', '0', '0', '', '禁止编辑 禁止删除', '3', '', '1', '[{\"label\":\"全部可见\",\"value\":\"{All:1}\"},{\"label\":\"部门及以下\",\"value\":\"{All:2}\"},{\"label\":\"只有自己\",\"value\":\"{All:3}\"}]'), ('265', '编辑', '/manage/system/admin-user/Edit', '0', '4', '1', '0', '', '', '3', '', '1', null), ('266', '组织结构设置', '/Manage/System/OrgStruct/Manage', '0', '7', '3', '0', 'ios-list', '', '2', '', '1', null), ('272', '查询', '/Manage/System/Params/Manage', '0', '2', '1', '0', '', '禁止编辑 禁止删除', '3', '', '1', null), ('273', '编辑', '/Manage/System/Params/Edit', '0', '2', '2', '0', '', '', '3', '', '1', null), ('281', '系统字典', '', '-1', '7', '2', '1', 'ios-ionic-outline', '', '2', '', '1', null), ('283', '工作人员类型', '/manage/system/IframeDict/UserType?dictname=工作人员类型', '0', '281', '1', '0', 'anticon anticon-bulb', '', '2', '', '1', ''), ('284', '数据可视程度选项配置', '/manage/system/IframeDict/DataDegree?dictname=数据可视程度选项', '0', '281', '2', '0', 'anticon anticon-question-circle-o', '', '2', '', '1', ''), ('285', '区域', '/manage/system/IframeDict/area?dictname=区域', '0', '281', '0', '0', 'anticon anticon-car', '', '2', '', '1', ''), ('310', '图文信息分类类型', '/manage/system/IframeDict/ArticleLabelType?dictname=图文信息分类类型', '0', '281', '3', '0', 'anticon anticon-solution', '', '2', '', '1', ''), ('311', '组织结构类型', '/manage/system/IframeDict/OrgStructType?dictname=组织结构类型', '0', '281', '5', '0', 'anticon anticon-tag-o', '', '2', 'OrgStructType', '1', null), ('313', '路段', '/manage/system/IframeDict/RoadSection?dictname=路段', '0', '281', '4', '0', 'anticon anticon-flag', '', '2', '', '1', null), ('317', '稽查记录审核失败的原因', '/manage/system/IframeDict/AdoptInfoAuditWrongCause?dictname=稽查记录审核失败的原因', '0', '281', '6', '0', 'anticon anticon-frown', '', '2', '', '1', null), ('318', '公告', '', '-1', '376', '1', '1', 'android-notifications', '', '2', '', '1', null), ('319', '公告管理', '/Manage/System/Notice/Manage', '0', '318', '1', '0', '', '禁止编辑 禁止删除', '3', '', '1', null), ('320', '公告编辑', '/Manage/System/Notice/Edit', '0', '318', '2', '0', '', '', '3', '', '1', null), ('341', '新闻动态', '', '-1', '376', '0', '1', 'ios-paper', '', '2', '', '1', ''), ('342', '图文信息分类', '/manage/CMS/Article/Label', '0', '341', '1', '0', '', '', '2', '', '1', ''), ('343', '图文信息管理', '', '-1', '341', '2', '1', '', '', '2', '', '1', ''), ('344', '查询', '/Manage/CMS/Article/Manage', '0', '343', '1', '0', '', '禁止编辑 禁止删除', '3', '', '1', ''), ('345', '编辑', '/Manage/CMS/Article/Edit', '0', '343', '2', '0', '', '', '3', '', '1', ''), ('349', '首页', '', '-1', '0', '0', '1', 'home', '', '1', '', '1', null), ('350', '默认首页', '/Manage/Main/index', '0', '349', '1', '0', '', '', '2', '首页', '0', ''), ('353', '烟田管理', '', '0', '0', '1', '0', 'social-windows', '', '0', '', '1', ''), ('354', 'API调试', '/Manage/System/debug-api/main', '0', '0', '5', '0', 'lightbulb', '', '1', '', '0', ''), ('355', 'CMS', '', '-1', '0', '3', '1', 'social-twitch', '', '1', '', '1', ''), ('356', '应用系统', '', '-1', '7', '0', '1', '', '', '2', '', '1', null), ('357', '应用系统管理', '', '-1', '356', '0', '1', '', '', '2', '', '1', null), ('358', '编辑', '/manage/system/platform/platform-edit', '0', '357', '1', '0', '', '', '3', '', '1', ''), ('359', '查询', '/manage/system/platform/platform-manage', '0', '357', '0', '0', '', '', '3', '', '1', ''), ('360', '系统套餐管理', '', '-1', '356', '1', '1', '', '', '2', '', '1', null), ('361', '查询', '/manage/system/platform/platform-rule-manage', '0', '360', '1', '0', '', '', '3', '', '1', null), ('362', '编辑', '/manage/system/platform/platform-rule-edit', '0', '360', '2', '0', '', '', '3', '', '1', null), ('363', '合作伙伴', '', '-1', '356', '2', '1', '', '', '2', '', '1', ''), ('364', '查询', '/manage/system/partners/manage', '0', '363', '1', '0', '', '禁止编辑 禁止删除', '3', '', '1', ''), ('365', '编辑', '/manage/system/partners/edit', '0', '363', '2', '0', '', '', '3', '', '1', ''), ('366', '人员职务', '/manage/system/partners/partners-dict/UserType?dictname=人员职务', '0', '4', '2', '0', '', '', '3', '', '1', ''), ('367', '个性化设置', '', '-1', '7', '6', '1', 'paintbucket', '', '2', '', '1', ''), ('368', '登陆页面', '', '-1', '367', '1', '1', 'icon-list', '', '2', '', '1', ''), ('369', '查询', '/manage/system/custom-theme/login-page-manage', '0', '368', '1', '0', '', '', '3', '', '1', ''), ('370', '编辑', '/manage/system/custom-theme/login-page-edit', '0', '368', '2', '0', '', '', '3', '', '1', ''), ('376', '内容管理', '', '-1', '355', '0', '1', '', '', '2', '', '1', ''), ('377', '功能模块', '', '-1', '355', '1', '1', '', '', '2', '', '1', ''), ('378', '网站发布', '/manage/cms/publish', '0', '355', '3', '0', '', '', '2', '', '1', ''), ('379', '查询', '/Manage/CMS/site-module/manage', '0', '377', '1', '0', '', '禁止编辑 禁止删除', '3', '', '1', ''), ('380', '编辑', '/Manage/CMS/site-module/edit', '0', '377', '2', '0', '', '', '3', '', '1', ''), ('381', '站点设置', '', '-1', '355', '2', '1', '', '', '2', '', '1', ''), ('382', '基础信息', '', '-1', '381', '1', '1', '', '', '2', '', '1', ''), ('383', '网站信息', '/manage/cms/setting/site-info', '0', '382', '1', '0', '', '', '3', '', '1', ''), ('384', '邮件发送设置', '/manage/cms/setting/mail', '0', '382', '2', '0', '', '', '3', '', '1', ''), ('385', '第三方代码', '/manage/cms/setting/script-code', '0', '382', '3', '0', '', '', '3', '', '1', ''), ('386', '栏目设置', '/manage/cms/setting/menu', '0', '381', '2', '0', '', '', '2', '', '1', ''), ('387', '文件管理', '/manage/system/file-manage', '0', '7', '8', '0', '', '禁止编辑 禁止删除 禁止下载', '2', '', '1', '');
COMMIT;

-- ----------------------------
--  Table structure for `iframe_tabelid`
-- ----------------------------
DROP TABLE IF EXISTS `iframe_tabelid`;
CREATE TABLE `iframe_tabelid` (
  `TabelName` varchar(50) NOT NULL COMMENT '表名称',
  `IDValue` bigint(20) DEFAULT '0' COMMENT '表ID值',
  PRIMARY KEY (`TabelName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `iframe_tabelid`
-- ----------------------------
BEGIN;
INSERT INTO `iframe_tabelid` VALUES ('iframe_dict', '846'), ('iframe_orgstruct', '8'), ('iframe_system_module', '387'), ('OrgSystemModule', '29');
COMMIT;

-- ----------------------------
--  Table structure for `iframe_user`
-- ----------------------------
DROP TABLE IF EXISTS `iframe_user`;
CREATE TABLE `iframe_user` (
  `UserID` varchar(36) NOT NULL,
  `UserName` varchar(50) DEFAULT NULL,
  `UserRealName` varchar(50) DEFAULT NULL,
  `UserJobNum` varchar(11) DEFAULT NULL COMMENT '工号',
  `UserPwd` varchar(50) DEFAULT NULL,
  `UserType` char(10) DEFAULT NULL COMMENT '人员类型',
  `UserHeaderImg` varchar(50) DEFAULT '' COMMENT '用户头像',
  `UserMobilePhone` varchar(15) DEFAULT NULL,
  `UserRule` varchar(50) DEFAULT NULL,
  `UserLoginIp` varchar(50) DEFAULT NULL,
  `UserPingYin` varchar(50) DEFAULT NULL,
  `UserCreatetime` int(11) DEFAULT NULL,
  `UserLoginTime` int(11) DEFAULT NULL,
  `UserIsSuper` int(11) DEFAULT '0' COMMENT '是否是超级管理员',
  `UserIsOnline` tinyint(4) DEFAULT '0' COMMENT '是否在线',
  `UserIsDel` tinyint(4) DEFAULT '0' COMMENT '是否被删除',
  `UserOrgStructID` int(11) DEFAULT '0' COMMENT '组织结构ID',
  `UserAccessToken` char(32) NOT NULL COMMENT '令牌',
  `UserPartnersID` int(11) DEFAULT NULL COMMENT '合作伙伴ID',
  `UserParentID` int(11) DEFAULT '0' COMMENT '父级ID',
  `UserParentIDs` varchar(50) DEFAULT NULL COMMENT '父级路径',
  `UserAreaCode` char(30) DEFAULT NULL COMMENT '所属区域',
  PRIMARY KEY (`UserID`),
  KEY `UserName` (`UserName`),
  KEY `UserType` (`UserType`),
  KEY `UserPingYin` (`UserPingYin`),
  KEY `UserParentID` (`UserParentID`),
  KEY `UserPartnersID` (`UserPartnersID`),
  KEY `UserOrgStructID` (`UserOrgStructID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `iframe_user`
-- ----------------------------
BEGIN;
INSERT INTO `iframe_user` VALUES ('1', 'admin', '超级管理员', '999999', '4qrcoum6wau+vubx8g+ipg==', null, '/res/images/header/default.png', '13759496259', '-9999', '127.0.0.1', 'CJGLY', '1412598693', '1549726100', '1', '0', '0', '-1', '6380DAC711289F063145A7C7A022A96E', '-1', '0', null, null), ('25', 'admin:1', '超级管理员', '0000', '4QrcOUm6Wau+VuBX8g+IPg==', null, '/res/images/header/default.png', '', '-9999', '', 'cjgly', '1529477858', '1537723965', '1', '0', '0', '1', 'D65BE33F9237752ADAEADCE67FBF00D8', '1', '0', null, null), ('C827C580-FFC0-0001-3340-17001D65135A', null, '田林', null, '4QrcOUm6Wau+VuBX8g+IPg==', '01', '/res/images/header/default.png', '13800138001', '63', null, 'tl', '1537928227', '1537933989', '0', '0', '0', '-1', '71CC3F9C897B92E99B2A0E862D5FB686', '-1', '0', null, '530000');
COMMIT;

-- ----------------------------
--  Table structure for `weixin_app`
-- ----------------------------
DROP TABLE IF EXISTS `weixin_app`;
CREATE TABLE `weixin_app` (
  `WX_ID` int(11) NOT NULL AUTO_INCREMENT,
  `WX_AppID` char(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '应用ID',
  `WX_AppName` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '应用名称',
  `WX_AppType` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '应用类型',
  `WX_AppSecret` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '应用密钥',
  `WX_AppToken` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信访问App服务端的令牌',
  `WX_AccessToken` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '访问微信服务器的令牌2小时过期',
  `WX_JsApi_Ticket` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '调用JSAPI的Ticket2小时过期',
  `WX_AccessToken_ExpiresTime` int(11) DEFAULT '0' COMMENT '过期时间',
  `WX_JsApi_Ticket_ExpiresTime` int(11) DEFAULT '0' COMMENT '过期时间',
  `WX_CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `WX_UpdateTime` datetime DEFAULT NULL COMMENT '更新令牌时间',
  `WX_EncodingAESKey` varchar(43) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '消息加密密钥由43位字符组成',
  `WX_Menu` text COLLATE utf8mb4_unicode_ci COMMENT '自定义菜单',
  `WX_WXNum` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信号',
  `WX_IsActive` tinyint(6) DEFAULT '0' COMMENT '是否激活',
  `WX_IsConcernAutoRequest` tinyint(6) DEFAULT '0' COMMENT '是否开启关注时自动回复',
  `WX_IsMsgAutoRequest` tinyint(6) DEFAULT '0' COMMENT '是否开启收到消息自动回复',
  `WX_ConcernAutoRequstContent` text COLLATE utf8mb4_unicode_ci COMMENT '关注时自动回复的内容',
  `WX_MsgAutoRequestContent` text COLLATE utf8mb4_unicode_ci COMMENT '收到消息时自动回复的内容',
  `WX_PartnersID` int(11) DEFAULT '0' COMMENT '合作伙伴ID',
  `WX_MchID` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信支付分配的商户号',
  `WX_CommercialName` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商户名称',
  `WX_PayPwd` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信支付API密钥',
  PRIMARY KEY (`WX_ID`),
  UNIQUE KEY `NewIndex1` (`WX_AppID`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
--  Records of `weixin_app`
-- ----------------------------
BEGIN;
INSERT INTO `weixin_app` VALUES ('10', 'wx811b2730c47cd27c', '法制在线', '2', '77FCEC6DFFB1448E9CA4AC6CB89C25EC', '48194989101549bc', 'bfUUzc2ik0XYnTNi9ggSglYDDGwvb_Fd3E8Qd-AFGNFTTv_VgtbuMtNRLllEm7XUst24FlkdvuwmVzpAxZTsDQxOzc23b6Hdz67Pqa4AmAIviHoEmYK7Q3PWjtFTvITTVITiABADQB', 'kgt8ON7yVITDhtdwci0qedUOg12FdmFFRa4WtA7_8cvR5W49jHKLHsMS0pMkKHLFtOJjCLHCVjGUNwyY5ST-cg', '0', '0', '2016-11-04 21:13:17', '2016-11-17 00:59:18', '2aeIECi5BRGrnUgOI9HYSXfaHQEwvWViye2UPydfAEF', '', 'cnyn124', '0', '0', '0', '', '', '0', '1247706801', '法治在线', '77FCEC6DFFB1448E9CA4AC6CB89C25EC');
COMMIT;

-- ----------------------------
--  View structure for `v_articleitems`
-- ----------------------------
DROP VIEW IF EXISTS `v_articleitems`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_articleitems` AS select `cms_article_items`.`Art_ID` AS `Art_ID`,`cms_article_items`.`Art_Title` AS `Art_Title`,`cms_article_items`.`Art_Label` AS `Art_Label`,`cms_article_items`.`Art_Imgs` AS `Art_Imgs`,`cms_article_items`.`Art_SignImg_s` AS `Art_SignImg_s`,`cms_article_items`.`Art_SignImg_b` AS `Art_SignImg_b`,`cms_article_items`.`Art_Content` AS `Art_Content`,`cms_article_items`.`Art_CreateTime` AS `Art_CreateTime`,`cms_article_items`.`Art_ReadCount` AS `Art_ReadCount`,`cms_article_items`.`Art_Intro` AS `Art_Intro`,`cms_article_items_label_code`.`AR_LabelCode` AS `AR_LabelCode`,`cms_article_items`.`Art_ArticleFrom` AS `Art_ArticleFrom`,`cms_article_items`.`Art_UserID` AS `Art_UserID`,`cms_article_items`.`Art_VideoPath` AS `Art_VideoPath`,`cms_article_items`.`Art_IsRecommend` AS `Art_IsRecommend`,`cms_article_items`.`Art_IsPreShowImg` AS `Art_IsPreShowImg`,`cms_article_items`.`Art_ViewStyle` AS `Art_ViewStyle`,`cms_article_items`.`Art_IsHide` AS `Art_IsHide` from (`cms_article_items_label_code` join `cms_article_items` on((`cms_article_items_label_code`.`AR_ArtID` = `cms_article_items`.`Art_ID`)));

-- ----------------------------
--  View structure for `v_iframe_partners`
-- ----------------------------
DROP VIEW IF EXISTS `v_iframe_partners`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_iframe_partners` AS select `v_iframe_platform_rule`.`RuleName` AS `RuleName`,`v_iframe_platform_rule`.`RulePlatformName` AS `RulePlatformName`,`v_iframe_platform_rule`.`RuleAble` AS `RuleAble`,`iframe_orgstruct`.`OS_ID` AS `OS_ID`,`iframe_orgstruct`.`OS_Name` AS `OS_Name`,`iframe_orgstruct`.`OS_Type` AS `OS_Type`,`iframe_orgstruct`.`OS_IsParent` AS `OS_IsParent`,`iframe_orgstruct`.`OS_ParentID` AS `OS_ParentID`,`iframe_orgstruct`.`OS_Admin_UserID` AS `OS_Admin_UserID`,`iframe_orgstruct`.`OS_Addr` AS `OS_Addr`,`iframe_orgstruct`.`OS_PlatformRuleID` AS `OS_PlatformRuleID`,`iframe_orgstruct`.`OS_PlatFormID` AS `OS_PlatFormID`,`iframe_orgstruct`.`OS_IsDel` AS `OS_IsDel`,`iframe_orgstruct`.`OS_IsShow` AS `OS_IsShow`,`iframe_orgstruct`.`OS_CreateTime` AS `OS_CreateTime`,`iframe_orgstruct`.`OS_Desc` AS `OS_Desc`,`iframe_orgstruct`.`OS_AreaCode` AS `OS_AreaCode`,`iframe_orgstruct`.`OS_Code` AS `OS_Code` from (`iframe_orgstruct` left join `v_iframe_platform_rule` on((`iframe_orgstruct`.`OS_PlatformRuleID` = `v_iframe_platform_rule`.`RuleID`))) where (`iframe_orgstruct`.`OS_Type` = '001');

-- ----------------------------
--  View structure for `v_iframe_platform_rule`
-- ----------------------------
DROP VIEW IF EXISTS `v_iframe_platform_rule`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_iframe_platform_rule` AS select `iframe_platform_rule`.`RuleID` AS `RuleID`,`iframe_platform_rule`.`RuleName` AS `RuleName`,`iframe_platform_rule`.`RuleInfo` AS `RuleInfo`,`iframe_platform_rule`.`RuleAble` AS `RuleAble`,`iframe_platform_rule`.`RulePlatformID` AS `RulePlatformID`,`iframe_platform_rule`.`CreateTime` AS `CreateTime`,`iframe_platform`.`IP_Name` AS `RulePlatformName`,`iframe_platform_rule`.`IsDel` AS `IsDel`,`iframe_platform_rule`.`RuleDict` AS `RuleDict` from (`iframe_platform_rule` left join `iframe_platform` on((`iframe_platform`.`IP_ID` = `iframe_platform_rule`.`RulePlatformID`)));

SET FOREIGN_KEY_CHECKS = 1;
